Issue the SQL command "PRAGMA synchronous = OFF;" Also, as I read and found out myself, wrapping large amounts of INSERT statements into a transaction (eg, issue a "BEGIN;" before and a "COMMIT;" afterwards) yeilds MUCH better performance, but at the price of locking the table. If you're using the database in single user mode, that shouldn't be an issue.
// CHRIS ----- Original Message ----- From: "boysen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 17, 2004 9:50 AM Subject: [sqlite] how to switch to asynchronous mode? > Hi, > > I just converted a DB from Oracle to SQLite and am now trying to improve > the performance. On the performance comparison page of the sqlite.org > website I read about an asynchronous mode, which performed faster in > many cases. > > How can I switch SQLite to asynchronous mode? > > Thanks in advance, > Bo > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
