Bugs item #723906, was opened at 2003-04-18 21:35 Message generated for change (Comment added) made by ejort You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=723906&group_id=22866
Category: JBossCX Group: v3.2 >Status: Closed >Resolution: Fixed Priority: 5 Submitted By: Stefan Reich (sreich) >Assigned to: Adrian Brock (ejort) Summary: setAutoCommit calls are performance problem Initial Comment: The calling sequence between BaseWrapperManagedConnection and InternalManagedConnectionPool result in two setAutoCommit() being made that are unnecessary in most situations. The attached microbenchmark shows that the associated costs are pretty high, since they go over the network. Results with Oracle 9i: 0.46717 ms/call for two setAutoCommit() calls 1.28526 ms/call for two setAutoCommit() calls with a simple query With local Transactions the calling sequence looks like this: start transaction, which sets AutoCommit to false // do stuff end transaction connection gets receycled in InternalManagedConnectionPool.returnConnection which calls cleanup() on the ManagedConnection, which sets AutoCommit back to true. Ideally, a setAutoCommit would occur once, or when the connection is used outside of a transaction. ---------------------------------------------------------------------- >Comment By: Adrian Brock (ejort) Date: 2003-09-15 10:31 Message: Logged In: YES user_id=9459 Fixed for jboss-3.2.2 ---------------------------------------------------------------------- Comment By: David Jencks (d_jencks) Date: 2003-05-22 21:26 Message: Logged In: YES user_id=60525 Apparently there is a problem in the jdbc wrappers since they are intended to change the underlying driver autocommit setting only when you actually do some work requiring the new setting. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=723906&group_id=22866 ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
