we tried (you have our example database form former issues) the latest version, did a statics create on startup and see that the queries are now around 5-10 times slower than before. see https://www.objectdb.com/forum/2845 for queries we are using
version 2.8.9_06 significantly slower for queries compared to 2.8.9
#1
hgzpincher
#2
support
Version 2.8.9_01 fixed an issue with queries (issue #2858) but had a known query performance regression. It was fixed in version 2.8.9_02 but maybe there is another relevant query performance regression that has not been fixed. Changes in versions 2.8.9_03 - 2.8.9_06 are not expected to affect queries.
An attempt to run the query from https://www.objectdb.com/forum/2845 (database size 20GB) with version 2.8.9_06 returns with immediate results (although zero results), so are you sure that this is the correct example to demonstrate the issue?
ObjectDB Support