On Tue, Jan 10, 2012 at 10:08 AM, John Elrick <john.elr...@fenestra.com>wrote:
> On Tue, Jan 10, 2012 at 8:31 AM, Richard Hipp <d...@sqlite.org> wrote: > > 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? > > Yes. > Have you run "SELECT sqlite_source_id();" to verify that your build is really picking up the version of SQLite that you think it is? Do you have code like this in your application: assert( sqlite3_libversion_number()==SQLITE_VERSION_NUMBER ); assert( strcmp(sqlite3_sourceid(),SQLITE_SOURCE_ID)==0 ); assert( strcmp(sqlite3_libversion(),SQLITE_VERSION)==0 ); To verify that your SQLite source code and "sqlite3.h" header file match? > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
