Re: [sqlite] Performance test on windows

I try an very long insert without BEGIN and COMMIT and this is very slow.. with a transaction is very very fast... just try and tell us the result Gaurav On 18/01/07, Ian Frosst <[EMAIL PROTECTED]> wrote: It could be that there is no transaction block wrapped around the inserts (a BEGIN

Re: [sqlite] Performance test on windows

It could be that there is no transaction block wrapped around the inserts (a BEGIN TRANSACTION before the start of the insert loop, and a COMMIT TRANSACTION at the end.) If there is no explicit transaction, then every insert has an implied transaction, which considerably slows down the database

[sqlite] Performance test on windows

Hi All, I am a newbie to SQlite, just saw that the performance numbers on www.sqlite.org are not reliable (as per the notce on website, http://www.sqlite.org/speed.html ) So, I thought of profiling SQlite operations, on linux platform the performance