Hello everyone, On mysql transactional tables, a commit is implied on each insert operation unless you turn off autocommit.
Most operations that involves multiple writes to the database can be made faster by grouping them inside a transaction, since it will mean fewer commits overall. For example I got a 40% performance boost during dbmail-smtp insertion on a few hundred messages by putting a begin/commit pair at the start and end of insert_messages (dbmail 1.2 cvs). Are there plans for this kind of thing in the 2.0 tree? A quick look at the code doesn't find much. It will also increase consistency after a crash since each message will be fully created or not created at all. -chris
