[Hibernate Query] Slow performance with Oracle as compared to MySQL
posted 6 years ago
We are using Hibernate for the persistent layer of our Java based web application.It has been observed that the application response time is significantly slow when using Oracle as compared to using MySQL.
Particular transaction (used as a abstract term) say transactionX takes approximately 18 Sec with MySQL. Same transationX when fired using Oracle as a database completes in approximately 55 Sec.
Is there any known issue with hibernate which must be causing this performance issue with Oracle?
We fired generated SQL statements directly from SQL editor. Our initial investigation directs towards use of joins, but not sure if this is the real culprit.