no difference, even if each statement is enveloped with "BEGIN;" and "COMMIT;". According to SQLite speed comparison chart, UPDATE should be somewhat slower than INSERT, but not that much. I'm using in-memory database, no sync.
Thanks, NK > On Mon, 17 Jan 2005 19:09:14 +0000, [EMAIL PROTECTED] > <[EMAIL PROTECTED]> wrote: > > > My question is, why did the two UPDATES take so much time, compared to > > INSERT. > > How fast are all those INSERTs and UPDATEs if you put them into a transaction?
