DataTables
Advanced interaction
features for your tables.
Editor
Comprehensive editing
library for DataTables.
Manual
Download
≡ Show site navigation

Server Side Datatable

Server Side Datatable

npr_newnpr_new Posts: 3Questions: 2Answers: 0
in DataTables 1.10

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.

DataTables

DataTables designed and created by SpryMedia Ltd.
© 2007-2023 MIT licensed. Privacy policy. Supporters.
SpryMedia Ltd is registered in Scotland, company no. SC456502.