Datables with 5000+ rows adding

piapple

I using datables.js whit boot strap3 for showing a lot of data that has more than 5000+,
First i query whole data from database and using php for loop to add each row of table (echo)
so it effected to website when rendering is very slow.

I trying to find a solution and i found that !! by using server-side processing
http://datatables.net/development/server-side/php_mysql
i was confuse in the example so much.

Anyone can explain to me how to use it or another example like this which have a detail of table that you using.

Thanks for advise

allan

Server-side processing is explained in detail here: http://datatables.net/usage/server-side .

Allan

piapple

Hi Allan,

Thanks for advise, I've just customise server-side. I used long time to set up because my project using MVC architecture also using Bootstrap 3. After that I was stuck in long time processing.

This are errors message after waiting 5 min process

1. Maximum execution time of 600 seconds exceeded in
2. DataTables warning: table id=customer_tb - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1

Thanks for advise

Bell

allan

Sounds like your server-side script is taking a very long time to run. It should really take milli-seconds to run, never mind timing out after 600 seconds. I can't really suggest what the issue is though, since I know nothing about your script.

Allan

piapple

Thanks Allan, That is my mistake about foreach data to array before encode json. I can fix it already and work fine. Now i trying to filtering of each column at tag. I found this http://datatables.net/forums/discussion/comment/20993. But i didn't found the way to using filler column with server-side.

Thanks for advise again.

Regards,

Bell

allan

When using server-side processing the filtering is done at the server - so you need to use the data DataTables sends to the server to do the filtering.

Allan