> 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: sqlite-users@sqlite.org 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. ---