php ajax server side processing hanging load 5m records
php ajax server side processing hanging load 5m records
![bala16](https://secure.gravatar.com/avatar/59dc2936a7585b723c376631e09e23d1/?default=https%3A%2F%2Fvanillicon.com%2F59dc2936a7585b723c376631e09e23d1_200.png&rating=g&size=120)
Hi,
I am using data tables Ajax server side processing. In data-tables i combine 5 tables and show data. total number records is 5m. its taking 20 secs. In data-tables only i need to show only 1st 10 record. loading time should too less. What can i do. I think pblm is loading more table in datatable. Please Can anyone guide how to give limit to all join tables. Thank you advanced.
This discussion has been closed.
Answers
Hi @bala16 ,
Take a nose this FAQ entry - it discusses ways to speed things up.
Cheers,
Colin