How to provide dynamic data load (per each page) for a huge data table

ilshual

Hello,

I would like to use DataTables to represent content of a huge table with about 100,000 records.
Standard paging functionality is great and that is exactly what I need. Performance in my project is a critical condition
User should be able to browse pages of the grid with minimal delay.
My question is the following: Is it possible to use full paging build-in capabilities but load data for required page only ?
(If there are 50 records per a page, I need to have an opportunity browse through all 2000 pages, but physically retrieve from my database only 50 records every time user clicks a page, instead of retrieve all 100,000).
Any ideas will be highly appreciated.
Regards, Ilya

allan

Yes, in DataTables this is called server-side processing. The data section of the manual has an overview of the two types of data processing modes in DataTables.

Allan

ilshual

Thanks Allan. Appreciate your help