Hi,

We recently face a big perfromance problem when with test our application with production database.

When we loop and commit() each row of a table, it seems that speed decrease a after each commit. We start at 1 sec per entity and finish with a 10 sec per entity. I had read that flush() can decrease the performance when calling to many time, but when we commit() the flush method is supposed to be call automatically.

So did someone already had this problems and found a solution?

Maybe is the configuration of hibernate?

<!-- SQL options -->
<property name="show_sql">false</property>

<!-- Pooling -->
<property name="connection.pool_size">10</property>

<!-- JDBC options -->
<property name="jdbc.batch_size">30</property>
<property name="jdbc.use_streams_for_binary">true</property>

<!-- other -->
<property name="max_fetch_depth">1</property>
<property name="cache.use_query_cache">true</property>
<property name="cache.provider_class">net.sf.hibernate.cache.HashtableCacheProvider</property>
<property name="cglib.use_reflection_optimizer">false</property>

This is my parameter.


Thank you for your help

lud

What part of the red box wasn't clear?