How to total /.accumulate entity table fields Cancel

1. Carl Verbiest

   

   59 posts
   Registered:
   12 Oct 2018
   13 Jul 2021

   Link to this post

   Use case :
   
   VAT declaration needs to process all invoices of a period.
   
   This can be thousands of entity tabel records,
   loading them all in memory will probably cause them to be written to disk.
   
   
   Should we batch or not ?
   If batching, can we / should we keep the BusinessEntity+DataAcess alive for faster processing of next batch ?
   
2. Mike Fechner

   

   319 posts
   Registered:
   14 Sep 2016
   13 Jul 2021 in reply to Carl Verbiest

   Link to this post

   "Should we batch or not ?"
   
   That really depends on size :) But probably yes.
   
   Assuming this is executed from a Business Task on the backend, successive calls to the Business Entity (via DatasetModel or any other method) should always be reusing the same instance anyway - as we're still within the same request.