Hi,

I've been spending some time investigating whether our application can be upgraded to use Hibernate 3.5.0 (from 3.3.1). I've found that one particularly query (14 joins) that worked fine and fast in the old Hibernate now joins 23 tables (the same, though many are joined twice) and this makes MySQL (5.1) choke (8.5 minutes to do an explain vs. instantly before).

I suspect some default joining strategy changed somewhere in between my versions, but I can't seem to find anything.

Any idea what's going on and what I can do about it?

Thanks,
Martin

I found something similar in my own application and found this: http://opensource.atlassian.com/project ... e/HHH-4091

It was solved by fixing the queries that used duplicate implicit joins.