> Wrap he updates in a transaction.
I'm already doing that (unless I'm doing it wrong?):
nRet = sqlite3_exec( m_pDB, _T("BEGIN;"), 0, 0, &szError );
...
nRet = sqlite3_exec( m_pDB, _T("COMMIT;"), 0, 0, &szError );
Luc
-----Original Message-----
From: Scott Wilkinson [mailto:[EMAIL PROTECTED]
Sent: January 22, 2005 12:14 PM
To: [email protected]
Subject: Re: [sqlite] UPDATE query: why is that code sooo slow?
Luc Vandal wrote:
>Hi,
>
>Perhaps I'm not doing things correctly, but this code will take about 1
>minute to execute (2400 records on a total of around 44000 records):
>
>
>
Wrap he updates in a transaction.
See http://www.sqlite.org/lang_transaction.html for the syntax.
--
Scott Wilkinson
MICROS Systems, Inc.
---
