Slow data extraction

Massimo74

I have a table of 2500 records and 40 columns which I elaborate in this way:
bStateSave: true,
deferRender: true,
bProcessing:true,
sAjaxSource: "php/myfile.php",
fnServerParams: function ( aoData ) {
aoData.push( { "name": "Tipo_Sel", "value": "PROG" } );
},
dataType: 'JSON',
sServerMethod: "POST",
createdRow: function ( row, data, index )
in doing so it takes about 100000ms and this seems abnormal, since it must also contain 5000/6000 records.

is there a solution to speed up this process ????
PS: The table at the bottom has the totals
Thanks.

kthorngren

in doing so it takes about 100000ms and this seems abnormal,

Is this the time it takes to fetch the data or for Datatables to draw the data once received at the client?

This FAQ explains some options.

Kevin