On Thu, Apr 07, 2011 at 10:59:50PM +0200, Szymon Guz wrote:
> Hi,
> this is maybe a stupid question, but I don't know how to explain to my
> coworkers why performing many inserts in autocommit mode is so much slower
> than making all of them in one transaction.
>
> Why is that so slow?
If you do BEGIN; [statement]; COMMIT; one after another, is that as
slow as autocommit? (My bet is yes.)
A
--
Andrew Sullivan
ajs@crankycanuck.ca