First, are both using the same version of the SQLite3 engine? Select sqlite_version(), sqlite_source_id();
Compiled with the same options? Pragma compile_options; Are they both using the same database file? How do the query plan's compare -- I would expect that they are significantly different in order to see such a variance in query execution. --- () ascii ribbon campaign against html e-mail /\ www.asciiribbon.org > -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Gert Corthout > Sent: Friday, 10 August, 2012 06:03 > To: sqlite-users@sqlite.org > Subject: [sqlite] SQLite Expert query execution speed > > > hello, > > we have noticed that executing a select query in SQLite expert is 3 times as > fast as executing it using our own C++ application. This seems quite odd as > we are doing no funky stuff in the code, the sqlite3_step alone in our app > takes longer then the entire process in (compiling the query, executing it, > and showing the results) does in SQLIte Expert. > Does SQLite Expert do something special? > > We use the following pragma's: > Pragma encoding = 'UTF-16' > Pragma page_size = 4096 > PRAGMA foreign_keys = ON > > thanks in advance, > Gert > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
