Database Performance Issue Upgrading JBOSS 3.0.4 to JBOSS 5.1.0
I am upgrading JBOSS from version 3.0.4 to 5.1.0, and have found some significant performance problems with database calls (in the attached examples these are delete SQL statements).
The code base for this application is identical between the two versions. The only difference is upgrading JBOSS and changing from a JSQL Database connection (to SQL Server 2005) in JBOSS 3.0.4 to MSSQL in JBOSS 5.1.0 (also SQL Server 2005).
After running JProfiler on the old and the new JBOSS versions against the exact same set of data, I am seeing a performance difference of up to 3 or 4 times slower in JBOSS 5.1.0.
It seems the new version uses Transactions as part of the DB Connection Process which the old version doesn't. Is this configurable, and can it be turned off?
Please see attached screen shots, looking specifically at line "replication.command.entity.RemoveEntityCommand.doCommand" and the processing steps below that line.
JBOSS 3.0.4 with a small number of records has an approx processing time of 6ms per invocation
JBOSS 3.0.4 with a large number of records has an approx processing time of 7.6ms per invocation
JBOSS 5.1.0 with the same small number of records has an approx processing time of 21ms per invocation
JBOSS 5.1.0 with the same large number of records has an approx processing time of 18ms per invocation
These performance decreases are not capable of dealing with the required load. Does anyone have suggestions on how to resolve this issue? Has anyone experienced something similar?
Regards,
Andrew
