IE8.0 : Improving Performance of Datatable on IE8.0

raul_lfc

Hi All, I am facing performance issue on the IE8.0. I have Data loaded from client side and have formatted data, I cant use ajax to fetch data due to some restriction.

When I have 5000 records datatable IE8 takes lot of time to load data.
Is there anything to work around? I know loading data from server side can have significant affect, but I can't load data using serverside.

here is my code
[code]
var oTable = jQuery('#example').dataTable( {
"aaData":abc,
"bDeferRender": true,
"bSortClasses": false,
"bProcessing": false,
"bStateSave": false,
"sScrollY":"500",
"bAutoWidth" : false,
"bJQueryUI": true,
});

[/code]

I am loading data on document.ready()

allan

> I cant use ajax to fetch data due to some restriction.

That's a shame, since that is basically the only way you are going to get a performance increase here. The basic problem with DOM sourced data is that the full table must be downloaded and then the contents of each cell read. That is slow in IE.

Allan

raul_lfc

Thanks Allan for your Reply.
Things that I worked out are:
1. I split the array in parts that contains the 5000 Records
2. Then first half of data is Added to the datatable on document.Ready, and rest I added on some mouse events like mousemove using [quote]fnAddData[/quote] function.

Still I am not getting improved performance!!

allan

We'd need a link to the page please to be able to see what is going on.

Allan

raul_lfc

Hi Allan,
I am sorry as our application belongs to intranet, so there is no link present as such from which we can access application from network other than my client network.

raul_lfc

Hi Allan,

We have created one 5k records example on link http://live.datatables.net/OPUH/17.
I am getting script unresponsive error on IE8. it seems default sorting took lot of time. on IE 8 Profiler _fnInitialise takes around 81 sec ,perticulary _fnFilterData (in our actual application)

allan

Unfortunately the live site has a bug in it at the moment and it doesn't work in IE8... I need to figure that out, but haven't been able to do so yet.

1.10.0-beta.2 has some performance improvements which will help. The other thing is, if you remove the search highlighting, does that help?

Allan

raul_lfc

Hi Allan,

Removing search highlighting functionality doesn't help much on the initial load !!
I have also used 1.10.0-beta.2, its having impact very little.