Handling large datas

blurrblurr

Hi
I was given only a html table that have 250 columns and 1800 rows of data.
I try out the datatables filtering and it works.
Problem is it will load very slowly. I have no option to rewrite the html table so that the table can be handle by server-side.
Is there anyway I can improve the loading time?

allan

Which aspect is slow (the Chrome performance tools will tell you)? DataTables initialisation, page load, something else? The DOM read of DataTables is already about as optimised as I know how to make it (if I knew how to make it faster, I would).

See also http://datatables.net/faqs#speed .

Allan

blurrblurr

HI Allan,
Slow in term of loading. Even when I do column sorting, it takes 10 secs. Funny thing is it run smoothly in Firefox!

allan

That's surprising. Can you link to the page so I can take a look and what the issue might be please?

Allan

blurrblurr

allan, the problem is I am using IE7. it works better after using IE8

allan

I'm not surprised its slow in IE7. Its Javascript engine is hundreds of times slower than all current browsers.

Use ajax loading with deferred rendering or server-side processing if you have to support IE7 (I feel bad for you if you do!).

Allan

blurrblurr

Well not me, my clients...