Client side and server side data loading in data table.

sgdasari

Can somebody please help me in finding the solution.

I need to load 500 records everytime on datatable out of 10000 records which I get after firing a query in CRM(backend). User can navigate through this 500 rows through pagination with page size of 10 rows at client side seamlessly and without any server hit but when user clicks on 50th page, the data table must fire an Ajax query to fetch another set of 500 records and load the data on the datatable.
What I'm trying to avoid is
1) Performance impact by loading all 10000 records at once because CRM query is quite complex and time consuming.
2) User experience impact and frequent server hit by using only server side processing and also keeping user wait for next 10 rows on next page click everytime.

Sorry if I'm not clear on this. Please let me know if I need to rephrase my question. Any help would be highly appreciated. Thanks.

allan

This example sounds like what you need.

Allan