I have a question regarding paging in RadGrid when the grid is already filtered.
I am using NeedDataSource event for binding the grid.
My datasource query is rather slow so I implemented custom paging and it is working fast as expected when paging the RadGrid when no filter is active.
But when I filter the RadGrid, the paging is very slow. Changing the page number lasts like when the grid is fetching the data when filtering.
I understand that the process of filtering cannot be faster because of my datasource query, but is there a way that I can make paging faster when my grid is filtered?
Thank You for your help.