Hi,

We're using Hyperjaxb 3 to persist schema derived classes.

We're experiencing significant performance issues while saving/reading large java object data from oracle..

Each save/read operation takes around 5 seconds.

can anyone please share how we can attempt to fine tune hibernate to improve the performance.

Currently we have following setting in hibernate configuration.

bean id="sessionFactoryCommercialPersistence" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSourceCommercialPersistence" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="current_session_context_class">thread</prop>
<prop key="cache.provider_class">org.hibernate.cache.NoCacheProvider</prop>
<prop key="hibernate.connection.release_mode">on_close</prop>
<!-- <prop key="hibernate.hbm2ddl.auto">create</prop> -->
</props>
</property>

i'll appreciate prompt response..

regards
taran