Can a batch size be configured for addOrUpdate?

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 you. Note that during our testing the maximum amount of rows it was possible to update via “Groovy and SQL Console“ tool without the request timing out was ~6 million.