-----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 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:
Ahh. The archives I was browsing must be a few days behind. Worked like a charm. Also discovered that the mcount and _moncount are symbols inserted by gcc when profiling is enabled.
Many thanks. I'd been stumped for a few days on this one. At least now I have a decent knowledge of the SQLite source :)
- -dan -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (Darwin)
iD8DBQFAX0aBU/zGB5xpbyoRAn/QAJ9O4FrBjPYqfqASXcZXRzTndYb+sQCeNK2c 4KxbYyRT2hYCsBc/CNTM7M0= =ugHG -----END PGP SIGNATURE-----
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]