Slow loading datatable
Slow loading datatable
deltaTango
Posts: 1Questions: 0Answers: 0
I have a web page that loads a mailing list of 2,200 names, in groups of 100. Here is the code:
[code]
$('#example').dataTable( {
"bJQueryUI": true,
"aLengthMenu" : [[50,100,150,200],[50,100,150,200]],
"iDisplayLength" : 100,
"aoColumns": [
{ "bSortable": false, "mDataProp" : "image" },
{"asSorting" : ["asc","desc"], "mDataProp" : "name"},
{"asSorting" : ["asc","desc"], "mDataProp" : "email"},
{ "bSortable": false, "mDataProp" : "action" }
],
"bServerSide": true,
"sAjaxSource": "ajax/list_get.php"
} );
[/code]
It's really not that much and it is set up to show only 100 at a time. But the more I click the next page buttons, the slower it gets. The first call and subsequent two or three are fast (1-2 seconds). By the fourth, there is a 8-9 second pause before the data loads. By the 6-7th, it's about 20-30 seconds.
Any idea why this would be? I optimized the whole page where I had some live() functions to the new on(), and I expected this to be the problem but it still didn't solve it.
I also just upgraded to data tables 1.9.2
[code]
$('#example').dataTable( {
"bJQueryUI": true,
"aLengthMenu" : [[50,100,150,200],[50,100,150,200]],
"iDisplayLength" : 100,
"aoColumns": [
{ "bSortable": false, "mDataProp" : "image" },
{"asSorting" : ["asc","desc"], "mDataProp" : "name"},
{"asSorting" : ["asc","desc"], "mDataProp" : "email"},
{ "bSortable": false, "mDataProp" : "action" }
],
"bServerSide": true,
"sAjaxSource": "ajax/list_get.php"
} );
[/code]
It's really not that much and it is set up to show only 100 at a time. But the more I click the next page buttons, the slower it gets. The first call and subsequent two or three are fast (1-2 seconds). By the fourth, there is a 8-9 second pause before the data loads. By the 6-7th, it's about 20-30 seconds.
Any idea why this would be? I optimized the whole page where I had some live() functions to the new on(), and I expected this to be the problem but it still didn't solve it.
I also just upgraded to data tables 1.9.2
This discussion has been closed.