How to determine optimal cache cache size when using Hibernate

AFAIK, Hibernate converts all sql to prepared statement form before submitting it to the database. When configuring an application, the size of the prepared instruction cache can be an important factor. How do I determine the optimal value when using Hibernate, given that it creates prepared statements under the hood.

+2


source to share


1 answer


Typically, you try to get such statistics from your database, after which the application will run its normal course for a certain period of time.



You can also enable statistics and SQL logging in your Hibernate configuration and analyze the received data.

0


source







All Articles