Slow Load Time on MySql Server
Slow Load Time on MySql Server
montyjones
Posts: 1Questions: 0Answers: 0
Hello
I have a developer using DataTables and they are using MySQL and DataTables to render approximately 800,000 records with calculations via math/finance pear function. Everything seems to be working well but the load time is very slow, between 15 to 30 seconds (depending on the browser) every time a condition is changed. At times IE and Firefox crash. I have had the developer strip the calculations to see if it would speed things up but it doesn’t. Does anyone have a solution to speed the page load time?
You can view the page here http://directrate.com.au/directrate/
Thanks
I have a developer using DataTables and they are using MySQL and DataTables to render approximately 800,000 records with calculations via math/finance pear function. Everything seems to be working well but the load time is very slow, between 15 to 30 seconds (depending on the browser) every time a condition is changed. At times IE and Firefox crash. I have had the developer strip the calculations to see if it would speed things up but it doesn’t. Does anyone have a solution to speed the page load time?
You can view the page here http://directrate.com.au/directrate/
Thanks
This discussion has been closed.
Replies
I've just had a look at the page (very nice!) and its loading 483 records from the DOM. Do I need to toggle any settings to see the large table? With 800'000 records, I'd recommend using DataTables' server-side processing mode for that number of records, as it will load only those records that are actually needed. How server-side processing works is described here: http://datatables.net/usage/server-side and there is an example here: http://datatables.net/release-datatables/examples/server_side/server_side.html .
Regards,
Allan