{"id":716,"date":"2014-09-02T08:15:41","date_gmt":"2014-09-02T08:15:41","guid":{"rendered":"http:\/\/www.nikola-breznjak.com\/blog\/?p=716"},"modified":"2015-08-17T10:56:38","modified_gmt":"2015-08-17T10:56:38","slug":"need-a-replacement-for-jquery-datatables-plugin-as-its-too-slow","status":"publish","type":"post","link":"https:\/\/nikola-breznjak.com\/blog\/stack-overflow\/need-a-replacement-for-jquery-datatables-plugin-as-its-too-slow\/","title":{"rendered":"Need a replacement for jQuery datatables plugin as it’s too slow"},"content":{"rendered":"

\"profile<\/a>
\nI’m a big fan of Stack Overflow<\/a> and I tend to contribute regularly (am currently in the top 0.X%<\/a>).\u00a0In this category (stackoverflow<\/a>)\u00a0of posts I will will be posting my top rated questions and answers. This, btw, is allowed as explained in the meta thread here<\/a>.<\/p>\n

So, my question<\/a>\u00a0was\u00a0as follows:<\/p>\n

I’ve been using jQuery\u00a0datatables plugin<\/a>\u00a0for about two years now and it worked great so far. The problem occured now when I need to load about\u00a045000<\/strong>\u00a0records at once (you click the button and wait for the page with the data to load) – the loading time is just too big to wait.<\/p>\n

Here are the tests I made using Chrome web browser (the data is from it’s Network tab using ):<\/p>\n

datatables plugin turned on:<\/em>
\n5476<\/strong>\u00a0records:
\n24 requests \u2758 256.26KB transferred \u2758 19.80s
\n(onload: 19.80s, DOMContentLoaded: 18.58s)<\/code>
\n45071<\/strong>\u00a0records:
\n34 requests \u2758 1.85MB transferred \u2758 11.1min
\n(onload: 11.1min, DOMContentLoaded: 11.0min)<\/code><\/p>\n

datatables plugin turned off (the jQuery datatables initialization is comented out):<\/em>
\n5476<\/strong>\u00a0records:
\n21 requests \u2758 255.84KB transferred \u2758 6.57s
\n(onload: 13.26s, DOMContentLoaded: 13.28s)<\/code><\/p>\n

45071<\/strong>\u00a0records:
\n31 requests \u2758 1.84MB transferred \u2758 2.0min
\n(onload: 2.0min, DOMContentLoaded: 2.0min)<\/code><\/p>\n

The\u00a0increase in load time<\/em>\u00a0that datatables make is over\u00a080%<\/strong>\u00a0for the 45k rows, and almost\u00a040%<\/strong>\u00a0for the 5k rows.<\/p>\n

So I was wondering if you guys know of any similar plugin that handles alot of rows (45000+) faster, or am I just missing the point by trying to load all 45000+ records in “one go”?<\/p>\n

Any suggestions are appreciated!<\/p>\n

The answer, by user Allan Jardine, was this:<\/p>\n

\n

From the DataTables FAQs (\u00a0http:\/\/datatables.net\/faqs#speed<\/a>\u00a0):<\/p>\n