> -----Original Message----- > From: Dan Thill [mailto:[EMAIL PROTECTED] > Sent: Monday, March 22, 2004 10:34 AM > To: [EMAIL PROTECTED] > Subject: [sqlite] Precompiled queries forcing db syncs? > > In short, when I switch to precompiled queries, according to gprof, it > looks like the DB is being synched after every call, even though I've > issued PRAGMA synchronous=OFF. As a result, using > precompiled queries is an order of magnitude slower.
Make sure you're compiling the queries *inside* your transaction boundaries. According to a message from DRH a few days ago, this is necessary to avoid syncing: On Mar 18, 2004, at 12:14 PM, D. Richard Hipp wrote: > To run a query within a transaction, you also have to compile > it within a transaction. To run a query outside of a transaction > it should be compiled outside of the transaction. -Ken
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]