Radgrid performance large table with Scrolling, Filtering, Sorting

[Simone]

Hello,

I would like to present about 10,000 records per page, I might need paging if more than 10000 records are on the table (Sql Server db).

I need filtering, and sorting, and scrolling.

I know there are several techniques to optimize radgrid, but I would like to know...

Which technique should I look at for loading and displaying data in this case?

Thanks,
Simone

[Radoslav]

Hi Simone,

Thank you for contacting us.

To optimize the performance in your case I suggest you to reducing the number of visible column as much as possible (either hiding some of the columns or removing them completely and extracting their values on the client using key values)
Also we have many optimization techniques for such a scenarios and I am sure some of them will be of great help for your project . The info below summarize the most important performance info we already have in our documentation resources:
Optimization Tips series in the blogs:
Optimization Tips:The Rad Managers for ASP.NET AJAX
Optimization Tips: Testing Page Performance
Optimization Tips: Using RadAjaxManagerProxy Controls
Optimization Tips: Using HTTP Compression

Optimizing the RadGrid performance.
Please review the following links on how to optimize the performance of RadGrid:
http://www.telerik.com/products/aspnet-ajax/resources/top-performance.aspx
http://www.telerik.com/help/aspnet-ajax/grdviewstatereductiontechniques.html
http://www.telerik.com/help/aspnet-ajax/grdsavinggridviewstateinsession.html
http://www.telerik.com/help/aspnet-ajax/radinputmanager_performance.html

Additionally please keep in mind that rendering  10000 rows could crash some of the browsers. Also the transfer of all data from server to client will take very long time to whole data to load. In the following links you could find information of problems related with rendering huge amount of data into the browsers:
http://stackoverflow.com/questions/996263/firefox-crashes-rendering-large-html-table-20-000-rows
http://stackoverflow.com/questions/3174490/is-there-any-limit-on-number-of-html-elements-that-browser-can-display-without-p
http://forums.aspfree.com/asp-development-5/response-buffer-limit-exceeded-34386.html

If you need further assistance, do not hesitate to contact us again.

Greetings,
Radoslav
the Telerik team