Pagination on server side data

virus

Hi all.

i am with datatables serverside processing . while processing sorting and pagination is not working.
This is my table settings.
[code]
$('#example').dataTable( {
"bProcessing": true,
"bServerSide": true,
"bSort": true,
"bPaginate": true,
"sPaginationType": "full_numbers",
"bJQueryUI": true,
//"sPaginationType": "full_numbers",
"sAjaxSource": "server_processing.php"


} );
[/code]
when i am changing "bServerSide": to false, thenn it is working..
what is the mistake i have done here.

if i had done no mistakes, then what is the use of setting bServerSide:true??

any ine know about this ???

cdaigle

Hi virus,

I believe that there are 2 ways to handle sAjaxSource. If you set bServerSide to true, then the server is supposed to handle the sorting, paging, filtering, etc. If you leave it out (or set to false), it simply loads the data from the server and uses the sorting/paging/filtering features from DataTables itself. The ServerSide stuff is good for when there are ALOT of rows (millions) and it makes more sense for the server to handle all the work.

If you go to Usage section of the site, you can see that Ajax and Server-side processing are separate sections, even though they both use sAjaxSource.

Hope this helps.

virus

Hi cdaigle..

Thanks a lot..