Can the filtered record count be updated in the background, separately from the main AJAX call?
Can the filtered record count be updated in the background, separately from the main AJAX call?
FrancoDev
Posts: 1Questions: 1Answers: 0
When dealing with millions of records and using complex filters, calculating the total number of records and the filtered count on every request can take too long. In my current stored procedure, loading and fetching the data only takes 0.025 seconds, but calculating the filteredCount takes more than 10 seconds. This is a problem, as I would prefer to display the data first and build the pagination afterward. Do you have any alternatives?
Answers
The only real alternative at the moment is to fake the filtered count at the moment I'm afraid. At some point I would like to implement some kind of "until it is finished" pagination, but it isn't something that I've worked on yet.
Allan