Dealing with large tables and sAjaxSource

steelers4582

I am new to DataTables and wanted to know if there is a way to call a function when you click Next or Prev to retrieve just the data for that range? I successfully implemented sAjaxSource to get a dataset but when it is very large, my browser freezes up since the response is very large. Thanks

allan

Yes - in DataTables terminology that is called server-side processing: http://datatables.net/usage/server-side .

How large is your data set? Have you enabled deferred rendering ( bDeferRender )?

Allan

steelers4582

The current data set is 17mb but could be larger also

allan

Wow - okay - server-side processing it is!

Allan

steelers4582

Is there a way to pass the range you want with previous and next buttons? I have the code basically done but it is using the entire query. I think I need to use iDisplayStart and iDisplayLength. FYI.. I am using a Coldfusion function to return my data.

steelers4582

I think I figured it out using a variation of http://datatables.net/development/server-side/coldfusion