0 Replies Latest reply on Apr 27, 2006 1:34 AM by erikture

    CMP 2.x and Cache vs cmp2.x jdbc2 pm

    erikture

      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