datatables cannot calculate total number for 40 million rows

enaeimifar

Description of problem:

Hi everyone.

I use mysql in my project. In one of the tables there are more than 40 million rows to display. To display this number of lines, I used server-side mode and pagination.

But the calculation of the total number of lines has encountered an error. Of course, the error is not from datatables side. Rather, mysql cannot calculate this number at all and return it to datatables.

What solution can be found for this problem considering that I don't want pagination to be removed.

Of course, a possible solution to solve this problem, mysql has a feature that can use an estimated number or an approximate number instead of the exact number, which is very fast. But I don't know how to replace this query with a query to calculate the total number of datatables.

allan

Hi,

What script / code are you using for the server-side processing? Is it our demo SSP class, one of the Editor libraries or your own code?

Allan