Hi Martin, I have a task to review performance of ProcessInstanceNodeDataEventMerger My idea is to reduce the number of delete inserts when processing events and try to do it incremental. That should improve performance. PS: I was planning to send an e-mail tomorrow announcing that in case you were already working on a fix for that. I assume you are not and I would be sending a PR soon.
On Tue, Nov 21, 2023 at 6:09 PM Martin Weiler <mwei...@ibm.com.invalid> wrote: > I looked into the new examples using data-index persistence addon - Neus' > PR#1813 [1] for serverless and Pere's branch [2] for workflow (great job > both!) - and they work without issues using single requests. However, under > some load (I used 'ab' for testing with a light concurrency of 10 parallel > requests) I ran into the following problems: > > (1) Large number of insert/delete calls (eg. for tables such as nodes, > definitions, etc) > > (2) Hibernate OptimisticLockExceptions / StaleStateExceptions > > (3) DB deadlocks > > (4) Error responses, slow response times > > The reason I am reaching out with this topic here is to find out if we are > aware of this issue, and if someone is already looking into or being > assigned to it? > > Thanks, > Martin > > [1] https://github.com/apache/incubator-kie-kogito-examples/pull/1813 > [2] > https://github.com/pefernan/kogito-examples/tree/example_data-index_persistence > > --------------------------------------------------------------------- > To unsubscribe, e-mail: dev-unsubscr...@kie.apache.org > For additional commands, e-mail: dev-h...@kie.apache.org > >
