It is time to post
new version of
my 1 mil. records demo now with pure
SQL Server paging, filtering & sorting. Basically this is very similar to how
RadGrid will execute queries internally when you work with
LinqDataSource, ObjectDataSource or
ANY other
DataSourceControl with
built-in server paging.
Furthermore,
RadGrid is smart enough to
not request all items in your collection by default if not needed even when you use direct binding via
DataSource property.
It is important to note that
RadGrid will not oblige you to use any special DataSourceControl, class or interface!
Conclusion: When you combine
pure server-side data operations with
pure JSON transfer between client and server, you can boost the speed of your web application to a great extent.
[source code]
Enjoy!