Skip to main content
Known Participant
Sep 1, 2023 6:06 AM UTC
Question

How to aggregate record data inspite of batchsize

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

7 replies

stefanhelzle0001
Brainy
Sep 1, 2023 7:56 AM UTC

I do not know of any limitations on aggregation except runtime. What exactly are you looking for?

Known Participant
Sep 1, 2023 8:05 AM UTC

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

stefanhelzle0001
Brainy
Sep 1, 2023 8:09 AM UTC

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.