bServerSide on server side

blurrblurr

I have a table with 150 columns and 400+ records.
when I load with dataTable it actually hang. I intend to use bServerSide so it will do all the process at server side.


$('#mainTable').dataTable( {
"bDestroy": true,
"bRetrieve": true,
"bSortClasses": false,
"iDeferLoading": 57 ,
"bProcessing": true,
"bServerSide": true,
"sAjaxSource": "table.html",
"fnServerData": function ( sSource, aoData, fnCallback ) {
$.ajax( {
"dataType": 'json',
"type": "POST",
"url": sSource,
"data": aoData,
"success": fnCallback
} );
}
} );

With only oracle and php generated HTML table, am I able to get bServerSide moving?
How to make it work?

allan

You can use any server environment you want. The requirements for server-side processing and the communication between the client and server are here: http://datatables.net/usage/server-side

Allan

blurrblurr

Hey tried several time but it keep saying
DataTables warning: Attempted to initalise DataTables on a node which is not a table:DIV
Does it able to read html table as output from server side?

I have only


........

Do I need to re write this page to cater for server side?

allan

I think you'll need to give us a link to the page for us to be able to say what is going wrong.

Allan

blurrblurr

I have convert the MSSQL to ORACLE and it works! thanks