Hibernate Config Connection Pool Size
Why Set 10 in Hibernate Config File for Connection Pooling? Size = 1 Is Built in Size. Why Need to Increase Size? .. .. 10. .. . 1 Answer from the Hibernate...
why set 10 in hibernate config file for connection pooling ? size = 1 is built in size.why need to increase size ?
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"">
<hibernate-configuration>
<session-factory>
....
<property name="connection.pool_size">10</property>
....
</session-factory>
</hibernate-configuration>
1 Answer
From the Hibernate API Docs.
Hibernate's own connection pooling algorithm is, however, quite rudimentary. It is intended to help you get started and is not intended for use in a production system, or even for performance testing. You should use a third party pool for best performance and stability. Just replace the hibernate.connection.pool_size property with connection pool specific settings. This will turn off Hibernate's internal pool. For example, you might like to use c3p0.
connection.pool_size indicates the maximum number of pooled connections. So it is better to keep it at a logical count. It depends on your application and DB how much it can handle. 10 is a reasonable count that will typically used as it is sufficient for most cases.
Alexander Ross has covered the video game industry for a decade, writing deep dives on game design, esports tournaments, VR developments, and gaming culture.
