Today I've spent another ~ 30 minutes to extend RadGrid client-side data binding demo to 1 mil. records from my previous post
and now you have caching and filtering included. All data operations are accomplished using famous Dynamic Query Library
however you can easily rewrite the demo to use SQL syntax instead if you want.
You can check the new example here
and download the source from here