Query performance regression when upgrading from 7.1.2 to 7.2.1

Hi,

Has anyone else experienced that the query performance has degraded when upgrading from 7.1.2 to 7.2.1?

Queries that used to take 20-40ms now take 100-500ms :-/

Are there any logging or statistics I can look into?

Hey @larsw

Thanks for reaching out. What kind of queries are we talking about here? Are you using projections or do you retrieve entities? What backend are you working with, is it the Lucene or the Elasticsearch one?

There is an upgrade to a Lucene 9.11 compared to Lucene 9.9 used in Search 7.1, as well as there’s an upgrade to ORM 6.6 (7.2 series - Hibernate Search).

I cannot think of anything obvious that we did in 7.2 and what would cause the performance regression.