On Wed, 20 Apr 2005, Klint Gore wrote:
>On Tue, 19 Apr 2005 12:40:51 -0500, William Hachfeld <[EMAIL PROTECTED]> wrote:
>> uint64_t t_stop = Now();
>>
>> assert(sqlite3_exec(handle, "COMMIT TRANSACTION;",
>> NULL, NULL, NULL) == SQLITE_OK);
>
>What happens to your insert times if you swap the above 2 lines? If you
>stop timing before you commit, I would have thought that the journal
>file writes have been timed instead of the database. If it's a new
>database then it's probably not going to make any difference, but if
>it's an existing larger database then it might.
I know the snippet above is from a test program, but don't ever put things
like sqlite3_exec() inside an assert()! I hope you're (OP) not doing this
in your application.
Christian
--
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \
