[Solved] Radgridview Performance with 1m records

[Abhishek Gairola]

Is there any way to improve performance with over 1 million records being loading in radgridview
currently it is taking over one minute to load

Can I load only 50-100 records at a time.
I am using datapager but it loads all records and displays only a particular number of records.
I would like if datapager could fetch only 50-100 records from the database at a time.

Is there any way to do it?

thank you!

[Vlad]

Hi,

 If these records are in memory the grid will show them at once in less than a second. You can check this demo for more info. If you want to retrieve records from a service it will be better to use paging similar to this example. 

Greetings,
Vlad
the Telerik team