Count 50k + records with filtering

[Anthony_Dob]

Hi all,

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?

Best regards,

Anthony

[Chitrakant27]

Hi @Anthony_Dob ,

You can use pagination concept to view more than 50k item in Dashboard . I am pasting a reference link in below so that you can get much more idea about it.

link-https://www.youtube.com/watch?v=aKsNOsGj72A

Thanks,

Chitrakant27

[Anthony_Dob]

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)