Thanks genman. We found the issue. The fetch size was not the same in the legacy and JBoss version of the code. It was 20 in our legacy server and is default value 10 in the JBoss version. After changing this, we saw a significant change in performance. But there is still a 40-50ms difference between the new and old server.
This 40-50ms extra time is taken by the rollback opearation. In our JBoss based server, while we return the connection back to the pool, we do the rollback to make sure that those transactions that are not commited by the application is rolled back. I am not sure if we should do this or it is already being done by the JBoss connection pool. Could some one please let me know if we should do the rollback before returning the connection to the pool (of course, we do call the connection.close method after this)? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3914515#3914515 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3914515 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
