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

Reply via email to