Server Side filtering and sorting freeze

jeanpaul2777

Hello,

I have an issue with filtering and sorting: I am retrieving data from Mysql (>15000 rows) and if I try to do server-side filtering or sorting, a processing popup appears and the script freeze. I have followed the example in the website but cannot succeed in solving this problem.
Here's my code:
[code]
$(document).ready(function() {
var oTable = $('#example').dataTable( {
"bProcessing": true,
"bServerSide": true,
"sAjaxSource": "php/server_processing.php",
"sDom": 'T<"clear"><"H"lfr>t<"F"ip>',
"aoColumnDefs": [
{ "fnRender": function ( oObj ) {
return 'ENSMUSG'+oObj.aData[0]+''; },
"mDataProp": null,
"sDefaultContent": "Edit",
"sClass": "my_class",
"aTargets": [0]
}
],
"fnDrawCallback": function () {
$('td.test').editable( 'table_edit.php', {
"callback": function( sValue, y ) {
/* Redraw the table from the new data on the server */
oTable.fnDraw();
},
"height": "14px"
} );
}
});
$("#example").dataTable().columnFilter( {
aoColumns:[
null,
{type: "text"},
{type: "text"},
{type: "number-range"},
{type: "number-range"},
null,
null,
{type: "select", values:['0','1']},
]}
);
});

[/code]

Here's my JSON response:
[code]
{"sEcho":0,"iTotalRecords":"17372","iTotalDisplayRecords":"17372","aaData":[ ......
[/code]

I think that sEcho should be 1 instead, or maybe I am wrong ? I dont understand the description in the website. Shall I overwrite this value in fnServerParam?
Thank you for your help
Best

JP

jeanpaul2777

let's delete "bServerSide": true,
then it works
basically to heavy for serverside processing
Best
JP