Question
How is the batch size configured in Pricefx? Are all records added by api.addOrUpdate always added in one big batch? Or can we programmatically make a commit or configure how big (maximum number of records) the batch is?
And if addOrUpdate does not do batches, can some API function handle updates in batches on their own or do we need to do it manually?
Answer
There is no limit to the amount of rows you can add using api.addOrUpdate, so it is up to your consideration. FYI maximum amount of rows I was able to update via “Groovy and SQL Console“ tool without the request timing out was ~6 million.