Skip to main content
V
vikashk7323
September 1, 2023
Question

How to aggregate record data inspite of batchsize

  • September 1, 2023
  • 7 replies
  • 0 views

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
stefanhelzle0001
Brainy
September 1, 2023

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

V
vikashk7323Author
September 1, 2023

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
stefanhelzle0001
Brainy
September 1, 2023

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.

Terms & ConditionsAccessibility statement