On Tue, Jan 10, 2012 at 8:14 AM, John Elrick <john.elr...@fenestra.com>wrote:
> I will have to get back to you on this. While running tests against > isolated queries, I noticed an unusual circumstance. When I isolate > the queries into a test program, running through our present > libraries, 3.7.9 is roughly 4 times faster executing the exact same > queries where it is running roughly 5 times slower in the context of > the application. As those queries do not execute in the same order, I > suspect that page swapping and caching issues may be involved. I'm > proceeding on that assumption. > Are you using the same compile-time options when building your application as were used when building the shell program? -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users