RadGrid efficiency

[Brett]

I have a RadGrid that I have over a million records on. Currently I use a select * to display everything in the grid, so people can click next, put in a search in the filter, etc.It otherwise works perfect for me.

Under heavy load, I was wondering if there is a more efficient way to use the RadGrid, so instead of doing a select * for all the records, I can select 20 records, but still have the filters on top and the search capacity to search all million records if someone does it at the top. 

Thanks!

[Shinu]

Hello,

 I hope you are using Custom paging to present only fixed set of records at a time. Check the following demo which implements the same.
Grid / Custom Paging
Also check the following forum thread.
RadGrid filtering and grouping wiht custom paging

-Shinu.

[Brett]

I sort of have custom paging working. The only problem is that when I click on the filter, it only filters the 10 records that I pulled. Is there a way to filter with all million records?

[Pavlina]

Hello Brett,

I suggest that you go through the forum thread below which elaborates on this subject:
http://www.telerik.com/community/forums/aspnet-ajax/grid/filtering-with-customized-paging.aspx

Greetings,
Pavlina
the Telerik team