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
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?
Check the generated SQL on your findByPrimaryKey call. Execute the same SQL manually. Are you getting a comparable response time? If so, you will need to tweak the database to get better performance.