> From: David F. Skoll [mailto:d...@roaringpenguin.com] > > On Wed, 3 Aug 2011 15:19:07 -0500 > Duane Hill <du...@duanemail.org> wrote: > > > I set MySQL to log all SQL queries. There has not been one query > > contained within a transaction. > > > MySQL supports this by doing a START TRANSACTION which can lead to > > COMMIT and ROLLBACK. > > Some databases implicitly begin a transaction with the first > SELECT/INSERT/UPDATE/DELETE statement and only commit when you issue > COMMIT. This is supposedly enabled in DBI by turning AutoCommit off, > and indeed the MySQL driver does that. So I think there are > transactions (or at least... the Perl developers think there should > be.)
Right. I can't find any BEGIN or START TRANSACTION in the BayesStore code, but nevertheless a transaction may be started the way you pointed out. Which may be bad for performances: they seem to last for the whole message scan. > Regards, > > David.
