Loading 500 rows (15 columns, most hidden) in DataTables is very slow

damaya1982

Hi all, using server-side processing for this. I have no pagination set up, because all rows need to be seen on the page at a time. I see that the server-side script takes mere seconds, but after that I wait 20+ seconds and finally Firefox asks me if I want to stop the script. I wait, and about 10 seconds later my data is in the DataTable. I am wondering, with no pagination and ~500 rows, is there anything I can do to speed things up a bit?

[code]
$(document).ready(function() {
$('#servers').dataTable( {
"bSortClasses": false,
"bDeferRender": true,
"bProcessing": true,
"bServerSide": true,
"sAjaxSource": "/datatable"
} );
} );
[/code]

Any suggestions appreciated greatly!

allan

Server-side processing is pointless without paging to be honest, since al rows are needed up front anyway.

How long does the server take to respond to the ajax request? Can you please link to a test page as noted in the forum rules.

Allan