4 messages in com.mysql.lists.javaNo autocommit in JDBC driver? extra ...
FromSent OnAttachments
Kevin Burton28 May 2004 15:58 
Kevin Burton28 May 2004 16:19.patch
Mark Matthews31 May 2004 13:25 
Kevin Burton01 Jun 2004 12:15 
Subject:No autocommit in JDBC driver? extra speed?
From:Kevin Burton (bur@sofari.com)
Date:05/28/2004 03:58:49 PM
List:com.mysql.lists.java

I enabled profileSql=true and noticed:

Query "SET autocommit=1" execution time: 33 Query "SET autocommit=1" execution time: 36 Query "SELECT * FROM FEED WHERE ID = '1'" execution time: 37 result set fetch time: 0

What's with all the autocommits? Isn't this redundant on MyISAM tables?. Is there any way to disable this via the connection URL?

Doesn't look like it:

http://dev.mysql.com/doc/connector/j/en/index.html#id2801179

Kevin

--

Please reply using PGP.

http://peerfear.org/pubkey.asc

NewsMonster - http://www.newsmonster.org/

Kevin A. Burton, Location - San Francisco, CA, Cell - 415.595.9965 AIM/YIM - sfburtonator, Web - http://peerfear.org/ GPG fingerprint: 5FB2 F3E2 760E 70A8 6174 D393 E84D 8D04 99F1 4412 IRC - freenode.net #infoanarchy | #p2p-hackers | #newsmonster