fnAddData timeout issue

andrewc

I am trying to add about 420 rows to a grid. I am currently using fnAddData however it is causing a MASSIVE delay.

Is there a way to speed up this function or is there a better solution?

dwaddell

Are you talking about the "script is still running" error and the browser kind of locks up?

andrewc

That's the one!

After investigating a bit I realised that I wasn't passing in the 'bRedraw' parameter which meant that it was redrawing it for every record!

My bad!

[code]
var oTable = $('#MyDataTable').dataTable();

// Add row to the datatable
oTable.fnAddData([
item1,
item2,
item 3
], false); // Adding false means it doesn't redraw the table.

[/code]