RE: [sqlite] Precompiled queries forcing db syncs?

2004-03-22 Thread Williams, Ken
> -Original Message- > From: Dan Thill [mailto:[EMAIL PROTECTED] > Sent: Monday, March 22, 2004 2:03 PM > To: Williams, Ken > Cc: [EMAIL PROTECTED] > Subject: Re: [sqlite] Precompiled queries forcing db syncs? > > > Ahh. The archives I was browsin

Re: [sqlite] Precompiled queries forcing db syncs?

2004-03-22 Thread Dan Thill
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 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 sur

RE: [sqlite] Precompiled queries forcing db syncs?

2004-03-22 Thread Williams, Ken
> -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 be