CODEWITHSUNDEEP
phpjquerydatatable
Eric T
Eric T

Reputation: 1026

DataTable unable to handle large data?

As title, I had pluged in DataTables but somehow when I tried to load a database that has 100k row it fails to load. Was it the plugin problem or any recommendation on handle this big data in table?

Upvotes: 0

Views: 1597

Answers (2)

dragonmantank
dragonmantank

Reputation: 15456

What do you mean by failed? Are you creating the table in PHP, outputting it, and then calling DataTable? Are you filling the table via an AJAX call?

I would install Firebug if you are on Firefox, or use the built-in tools in Chrome or Safari. They will tell you if the JS is encountering an error, or let you inspect the responses from AJAX requests.

Upvotes: 0

Gaurav
Gaurav

Reputation: 28755

It depends on your php configuration.

Memory limit and maximum execution time in php.ini should be enough to get such large number of records.

And look at Increasing PHP memory_limit. At what point does it become insane?

Upvotes: 1

Related Questions