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?