Hello!
I am using Jboss 4.0.3 and MySql.
I am using CMP2.0 för all databaseaccess.
My application is 99.9% reading. Very litle writing.
Previously I have used a container configuration like the one below.
<container-configurations>
<container-configuration extends=
"Standard CMP 2.x EntityBean">
<container-name>CMP 2.x and Cache</container-name>
<commit-option>A</commit-option>
<insert-after-ejb-post-create>true</insert-after-ejb-post-create>
<call-ejb-store-on-clean>false</call-ejb-store-on-clean>
</container-configuration>
</container-configurations>
I have found out that the standard configuration is cmp2.x jdbc2 pm.
My question is which configuration gives the best performance?
JBoss is the only application accessing the database.
/Erik