Server Side Datatable

npr_new

Hi,

The datatable is too slow when displaying 70k records. I tried to manually run the stored procedure in SQL but it display around 2 seconds only. I am wondering why it is too slow displaying in the client side. I am not using paging as i have checkbox where i need to select records for these 70k results.
Any ideas on how to optimize?

Thanks,
Noel

colin

You would need to enable server-side processing for that many records. For server-side processing, enable serverSide. The protocol is discussed here. Also see examples here. If you download the DataTables repo, there are examples of the server-side scripts in /examples/server_side/scripts,

Cheers,

Colin