pre-fetch next table page

jblackwood

I'm using DataTables to display results from a large database, and each page of data takes approximately 15s to generate. Is it possible to pre-fetch the next page's data so that loading times appear faster? )

sd_zuo

I think you should load 1000 rows of record, fill the table, and do the pagination at the client-side rather than requesting 10 each time and paginate on the server-side.
Another option is to use two DataTables and switch their visibility alternatively.

iuliandum

Hi, jblackwood

See in next example.

http://www.datatables.net/examples/server_side/pipeline.html