15k record...

narutimateum

dear mr allan...i need to know how do i handle datatable with a 15k row of data???.....its getting quite inefficient for me since the browser tends to crash or become unresponsive...

d_vineet

@narutimateum,
For a large dataset, there is a fantastic plugin.
visit the link--
http://www.datatables.net/release-datatables/extras/Scroller/server-side_processing.html
Secondly, as the docs say, IE may crawl if there is a large data set.

numberone

You should use server-side scripts.
http://datatables.net/release-datatables/examples/data_sources/server_side.html

If you need to use join statement in your query, custom columns and more, You should check IgnitedDatatables library. https://github.com/n1crack/IgnitedDatatables-native-php-version

Regards,
Yusuf

allan

As d_vineet and numberone note, server-side processing might be the way forward as that will cope with many millions of rows. You might also want to check out the deferred rendering option: http://datatables.net/release-datatables/examples/ajax/defer_render.html

Allan

narutimateum

wee...many thanks y'all.... :D

narutimateum

i have a mystery though...my datatable seems to be generating semi colons on top of my table outside of the;;;;;;;; = to how many row i have...any1 know what is this suppose to be??

allan

No idea I'm afraid - I would imagine a spare echo or spare semi-colon in your generating code somewhere. DataTables wouldn't inject a comma like that (I've not seen it crop up anywhere else). Looking at the "View source" option in the browser might give a clue.

Allan