DataTables seems very slow in IE9

jamesjw007

I am using your most recent version of DataTables.

I am returning 4,048 entries from a recordset and throwing them into a table.

FireFox performs this in a matter of seconds.
IE9 Does this in around 20 seconds.

I have tried to turn off bSort, bSortingClass with no real significant gain.

The page seems to load, and then freeze while DataTables is trying to convert it from a very long list of rows into the DataTable. Any idea what could be wrong or how to speed this up in IE9?

snarf2larf

At 4048 entries I really think it would be better for all browsers if you used server-side processing. IE always ends up being the bane of web development it seems.

allan

I presume from your description you are using Ajax sourced data - try enabling deferred rendering - you should see a big speed increase: http://datatables.net/release-datatables/examples/ajax/defer_render.html

Allan

jamesjw007

Hi Allan,

I tried that as well as turning off sorting, sorting classes. The IE page loads in about 4 seconds or less. The loading modal I have dissapears as it should. At this point it seems DataTables in every browser does what it should do almost instantly.

But in IE, after the page technically seems to load. IE then takes about 25+ seconds to convert the table into a DataTable.

jamesjw007

Also this isn't Ajax. I started with it being Ajax, but this made it slow in all browsers. I call the classic asp code directly from the page load it into a Record Set and loop through the record set on the page.

I'm not sure if there is a better way to perform this than without doing server side processing. If I can avoid that I would like to as I have never set that up before.

snarf2larf

When you are using AJAX, were you returning all 4000+ rows? If you set it to return 25-100 rows it should be pretty speedy unless there is an issue with your database. Then on each page load it will get the next X amount of records. I have a datatable that queries the database through AJAX with over 2 million records limited to 25-100 rows and it goes from page to page in around a second.

jamesjw007

I might have to go that route. I've never done the paged SQL stuff before. Going to have to learn it. :)

jamesjw007

I need to do this in classic asp. Is it possible to hand off server side processing with classic asp instead of the provided php?

allan

Yes - the protocol for exchanging data between the client and server is documented here: http://datatables.net/usage/server-side .

There is an example SSP script for classic ASP here: http://datatables.net/development/server-side/asp_classic (provided by a 3rd party I'm afraid - I can't really offer any support for it!).

Allan

jamesjw007

No problem, I can work from that. Thank you very much you and the third party! :)