Inserting Large numbers of records in datatable at a time.

bharat

I am using DataTable to dynamically load data using AJAX from php service(in JSON format), parse them and Add them to datatable as a whole using fnAddData() function.
Source is like:
[code]
for(var i=0;i

allan

When you say large, how large? And what browser? Also have you enabled deferred rendering?

Allan

bharat

Here, Webservice will return large number of array of objects (about 200K to 800K).
I tested in Mozilla Firefox, Chrome, and Internet Explorer.
And I have enabled deferred rendering and infinite scrolling using:
[code]
fTable = $('#fileTable').dataTable({
.... ,
"bScrollInfinite": true ,
"bDeferRender": true,
....
});
[/code]

I can's use direct AJAX datasource to datatable because dataobjects that are returned by webservice are first processed as per some requirements and then array is builded and that is inflated in datatable.

Bharat

allan

Okay 800K rows is going to be asking too much of the browser I'm afraid. At that point you really need to consider using server-side processing, as the browser is just going to get killed trying to process that much data.

Allan