1 Reply Latest reply on May 15, 2003 8:28 AM by Corby Page

    Performance problem

    divine Newbie

      I got a problem about the performance. When the data more than 900,000 rows. I use standard EJB method to access a row,
      1. find by primary key --> 3203 ms
      2. remove --> 1563 ms
      3. create --> 401 ms
      4. set 7 fields --> 302 ms

      My PC:
      OS:WIN2000 SP2
      DB:MS SQL Server
      JBOSS:both 3.0.0 and 3.2.1(the same results.)
      standard CMP Entity 2.x commit-option C

      If I want to improve the performance, any suggestion?