I have to aggregate data based on a column. With aggregate will I get all the Data if the DB contains > 20,000 records. How to achieve it
Discussion posts and replies are publicly visible
I do not know of any limitations on aggregation except runtime. What exactly are you looking for?
My doubt is that in the record, batch is of 5000 but in the table when data exceeds 5000 then also will the aggregation fields work. Thanks
Don't worry. The batch size is only about the data returned by the query, but not applied to aggregations.
But, aggregation also costs time. If you have a specific use case that you need to perform more often, it might be a good idea to aggregate at the time of writing instead of at query time.
The aggregation I have to use for the filter, Thanks for the confirmation
What kind of filter do you mean? A user filter in a record?
Yes Record filter
So you do that query every time a user navigates to that UI. I have seen very bad performance impact of such dynamic user filters. Keep an eye on query time.