> Danny Reinhold wrote: > > DRH tested inserts with and without transactions on several > > DBMSs. PostgreSQL and MySQL where faster _without_ > > explicit transactions. > > That looks a bit strange to me... > If you are referring to Test 1 and Test 2 at http://www.sqlite.org/speed.html, > please look again. The transaction-less test (Test 1) only inserts 1000 > records, whereas the transaction test (Test 2) inserts 25000 records. So > even though the elapse time is a little more for some engines on the second > test, they are doing 25 times more work, so they are really quite a bit > faster. Ah yes, I see. Sorry.
- Danny -- Danny Reinhold Reinhold Software & Services --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]