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

Reply via email to