we are using version 3.5.x of the Community Edition successfully as an embedded DB in a project. There we store a pretty simple category tree. But each category node has a lot of properties. We rebuild that tree pretty often and recognized a huge performance decrease from 3.5.x to 4.x (does not matter if 4.0.x, 4.1.x or 4.2.0). The "setProperty" method gets slower the more properties are set. This is something we do not see with 3.x. There it stays at the same speed.
It also does not matter how often we commit. And we also played around with the DB settings. It all does not make any difference.
What might go wrong here? I could provide sample Java code and statistics if needed.
sorry for the late response didn't see your message.
it would be great if you could provide that code best as a GitHub issue, so that our benchmarking team could look into that.
thank you for the response. I have some code here:
There are two different branches in the repo. One with 3.x and another one with 4.x.
Hope that helps and thanks for taking care.
any news on this topic?