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 <[email protected]> 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: [email protected] > For additional commands, e-mail: [email protected] > >
