DataTable without expensive counting

rosinscj

We are dealing with database tables that contain millions of records, complex filtering, etc so counting is very expensive.

count: -- query took 14.9355 second(s) to execute -- 1 row(s) affected
data: -- query took 0.0483 second(s) to execute -- 10 row(s) affected

I found these two posts regarding using the datatable w/ an unknown count:

http://datatables.net/forums/discussion/4655/server-side-processing-with-unknown-itotalrecords-count/p1
http://www.datatables.net/forums/discussion/16925/server-side-paging-with-unknown-record-count/p1

Has this been built into the core yet? I will look into the pull request in the one post, but figured I'd post this while I review.

Thanks!

rosinscj

Update:
The pull request in the following topic does exactly what I need.
http://www.datatables.net/forums/discussion/16925/server-side-paging-with-unknown-record-count/p1

I had to modify slightly since we are on 1.9.4 and the pull request was on 1.9.1.

Thanks!

allan

This functionality isn't built into the core yet. There are still a number of UX issues that need to be resolved, and I've been building up other features that I think are more urgently required for 1.10. This is something I will look into in future though.

Regards,
Allan

rosinscj

Thank you for the response.