Server Side Datatable

Server Side Datatable

npr_newnpr_new Posts: 3Questions: 2Answers: 0

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

Answers

  • colincolin Posts: 15,177Questions: 1Answers: 2,590

    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

Sign In or Register to comment.