How Optimize DataTable Load

RCheep

Hi I have a problem, when the result query is big my datatable loads very slow

$('#datatable-icons').dataTable( {
"processing": true,
"serverSide": true,
"deferRender": true,
"initComplete": function(settings, json) {
$(".btn").tooltip();
},
"ajax": {
"url": "....",
"type": "POST"
},
"columns": [
{ "data": "type" },
{ "data": "data1" },
{ "data": "data2" },
{ "data": "created" }
]
} );

tangerine

...when the result query is big...

What do you mean by "big"?

RCheep

resutlRows > 50, 000