Data table with large amount of data.

balvir

Hi ,

I am using dataTables in my project. List has thousands records with 40 columns. I implemented dataTable this way:

https://datatables.net/examples/ajax/objects.html

It first time load my page with very fast speed then ajax run and return json data and in end show as html from json data after load all data it works as client side. everything is working correct.But main problem is my php script which get data from database and create json for datatable that data is of very large amount approx takes 13 secs for 2000 records. Data have 2000 rows and 40 columns which comes from different 10 tables with left joins. SO user have to wait long time for see the list.

The ajax run on starting get all data (2000 records) from script. But I want that ajax request get limited records on first time and again automatically ajax run and get next few rows. So multiple ajax hit for that data so ajax response time take less. But other functionalities of datatables like sorting, searching, export data etc should on client side as working now.

Can you give me solution how we can set code that ajax run multiple time for get limited data and show ajax response fast on page.

Please also keep in mind that other functionalities of datatables like sorting, searching, export data etc should on client side as working now.

Thanks.
Balvir

allan

See the speed FAQ.

Allan