Page Load time issue with more than 5000 rows

datatablesmohit

Dear All,

I've got a big table (5 to 10 thousand rows) with data and works alright with respect to sorting, pagination, and filtering after page load.
But the problem here is, it takes too much time (2 mins in Firefox) to load the page. And sometime in IE8 or IE7, page does not load.
Any solution or workaround to this?

allan

How are you loading the data? It is an Ajax source (in which case enable deferred rendering) or HTML (in which case have you considered Ajax source data)?

Allan

datatablesmohit

Thanks Allan.
I am using Datatables 1.7.5. I am using HTML table as the table data is a String which contains List of List of String. Also, the first column is checkbox. I am not using Ajax source as I cannot bind string to that (as it expect a file path).

How do I pass String in Ajax source? If I can pass then How can I pass checkbox dom element in that String?

I tried using Datatables 1.8.2. I set bDeferRender to true. But, in IE8 I am getting an annoying pop-up to confirm "Continue script". Even, I get this pop-up when I sort by checkbox column (which push 1 if checked else 0).

allan

bDeferRender will only work with Ajax sourced data. Basically there are too many operations happening which is what is triggering the IE error - so you need to think about either moving to Ajax sourced loading of server-side processing. There is an example of Ajax source loading here: http://datatables.net/release-datatables/examples/data_sources/ajax.html .

You could try DataTables 1.8.3.dev nightly from the downloads page as I have put in a number of changes to try and speed things up for IE, but I think you are still pushing the boundary of what it will allow in this case. Ajax source is the way to go with this many records :-)

Allan