I have a dashboard in my application that shows counts of particular records with a certain filtration. Let's say
10 records are New
20 records are processed
30 records are done
This will only work until 50k records as CountRows does not support over 50k records with filtration. I am looking for suggestions to keep a count for this situation after the filtering hits over 50k records.
A idea i had is to have a seperate table that has 'CounterRecords' this would look like this
New total count: 10
Processes total count: 20
Done total count: 30
Every time a record would go from New to Processed i would increment Processed and decrease New. I would do the same for other 'Status changes'. However i have a lot of 'CounterRecords' and this would mean that i would need to implement this everywhere in the application where records would change from 'Status'.
What would you guys suggest for this scenario? Any 'easier' methods/approaches?
This does not really solve the problem for me. Viewing large data is no problem as my queries are delegable. However i want to see the count of a filtered table even when it hits over 50k results (fetching 50k+ records in memory is no option)