IE runs slowly with large amounts of data

IE runs slowly with large amounts of data

SgsweenSgsween Posts: 2Questions: 0Answers: 0
edited January 2013 in DataTables 1.9
I've seen a lot of this on the forum and I've tried several suggestions. Below is where I'm at, looking for some suggestions.

Scenario:
20 - 30 data tables on a page (this is dynamic)
24 columns, 12 visible the rest hidden
3000 - 5000 rows total spread in all data tables
Can be up to 1000 in some tables (never more than 5000 in all tables)

I was using an older version of datatables (1.7.5). This was fine in chrome, FF, but in IE was taking way too long. After reading forums I upgraded to 1.9.4 and turned on bDeferRender and off bSortClasses.

Chrome is fast max 1.5 seconds with a total of 2000 rows across all tables.
IE8 700 - 100 across all tables, ok 3 seconds. But when I crank it up to 2000 IE throws the long running script message.

From what I understand IE throws this error when a max number of js scripts have run, which do to the number of rows, columns, and tables we are probably well over.

Has anyone run into this and found a way around it?

Replies

  • allanallan Posts: 63,498Questions: 1Answers: 10,471 Site admin
    30 odd tables on a single page? That's good going that! Do you need to load them all immediately? Or are they in tabs and they could be loaded at a later time, spreading the load?

    You might also want to consider using server-side processing: http://datatables.net/faqs#speed . Although 30 odd Ajax requests on page load might be something your server objects to...

    Allan
  • SgsweenSgsween Posts: 2Questions: 0Answers: 0
    about half need to open on page load, but that could vary. server side is something I'm considering but trying to avoid. I've already written a lot of client side code that might have to be moved to the server if I go that way.
This discussion has been closed.