I wonder if Corticon's EDC does support batch processing as specified by Hibernate by using the property hibernate.jdbc.batch_size.
Some background info:https://vladmihalcea.com/2015/03/18/how-to-batch-insert-and-update-statements-with-hibernate/
I did a small test with a Corticon project but adding the settings to the Database Access properties doesn't seem to have any effect. If it is possible, what settings are needed to have it activated for Corticon?
We've investigate this previously and it does not have the desired benefits. Features we depend upon like identity strategies and 2nd level cache are not compatible with hibernate batch; at least in how Corticon uses them. Batches can only be for a single table. Operations on other tables closes the batch and starts another one.
James Arsenault | Product Development | Progress Software email: firstname.lastname@example.org | direct: 781-280-4934
Prashant Thumma | Software Architect - Progress Corticon | email@example.com
Thank you both for your answers!
@Jim: What you're stating can be true. But I've seen at different customers that in one rulesheet multiple entities are created; all the same. It would be very interesting to be able to handle them in little batches.
@Prashant: The samples you show seems to refer to the blog link/similar example. But can the same effect be achieved using Corticon Studio? I created a small project with a rulesheet creating entities. But insert queries are not combined (as far as I can see).
Actually, I've used the settings with the HPBP and did see reduction of executions and better performance (20% reduction in time).
So, the question remains how to achieve these settings to work with Corticon.