, all works fine at the begining, after a few queries the request begin to be slowly.
I assume that it related to the connection pool, so this is my configuration of the connection pool in th fibernet.cfg.xml file
<property name="dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
<property name="show_sql">false</property>
<property name="use_outer_join">true</property>
<property name="connection.autoReconnectForPools">true</property>
<property name="connection.autoReconnect">true</property>
<property name="c3p0.min_size">3</property>
<property name="c3p0.max_size">20</property>
<property name="c3p0.timeout">10</property>
<property name="c3p0.acquireRetryAttempts">30</property>
<property name="c3p0.acquireIncrement">5</property>
<property name="c3p0.idleConnectionTestPeriod">9</property>
<property name="c3p0.initialPoolSize">20</property>
<property name="c3p0.maxPoolSize">50</property>
<property name="c3p0.maxIdleTime">300</property>
<property name="c3p0.maxStatements">50</property>
<property name="c3p0.minPoolSize">10</property>
Login
FAQ
Search