Datatable taking too much time to load in PHP.

srustita

Hi Allan,

I am using jquery datatable. I am fetching data through object from a class. But its taking 17 seconds to load only for 1724 records.

Here is the snippet.

$(document).ready(function() {
$('#datatable').dataTable({
dom: 'Bflrtip',
buttons: [
{ extend: 'excelHtml5', text: 'Get Excel' }
],
"sScrollY" : "300",
"sScrollX" : true,
"bScrollCollapse" : true,
//"bSort" : true,
"iDisplayLength": 5
}
);
});

Please help me.

allan

Thanks for your question - however, per the forum rules can you link to a test case showing the issue please. This will allow the issue to be debugged. For example, is it the PHP that is taking so long, or the Javascript.

Information on how to create a test page, if you can't provide a link to your own page can be found here.

Thanks,
Allan