I tried and got this: D:\Temp\Test>timethis custom\sqlite3console database.sqlite < query.sql
TimeThis : Command Line : custom\sqlite3console database.sqlite TimeThis : Start Time : Thu May 24 18:42:51 2012 TimeThis : End Time : Thu May 24 18:42:54 2012 TimeThis : Elapsed Time : 00:00:03.421 D:\Temp\Test>timethis custom\sqlite3 database.sqlite < query.sql TimeThis : Command Line : custom\sqlite3 database.sqlite TimeThis : Start Time : Thu May 24 18:42:59 2012 TimeThis : End Time : Thu May 24 18:43:06 2012 TimeThis : Elapsed Time : 00:00:07.078 D:\Temp\Test>timethis sqlite database.sqlite < query.sql TimeThis : Command Line : sqlite database.sqlite TimeThis : Start Time : Thu May 24 18:43:09 2012 TimeThis : End Time : Thu May 24 18:43:13 2012 TimeThis : Elapsed Time : 00:00:03.609 This latter is my build of the command line tools which is 800K. This is on a 2Ghz AMD Turion. --- () 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 Jonas Malaco Filho > Sent: Thursday, 24 May, 2012 18:15 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] SQLite SELECT performance problem > > I've tested your database and query, using the official sqlite3.exe and the > versions I compile myself (Microsoft Visual Studio 2010, x86 and x64): > > - Official (x86): ~5s (CPU Time: user 1.965613 sys 2.527216) > - Compiled by me (x86): ~1s (CPU Time: user 1.154407 sys 0.187201) > - Compiled by me (x64): ~1s (CPU Time: user 0.904806 sys 0.218401) > > My SQLite compilation options differ from the default values (so this does > not address the weird behavior you described), but maybe it can still be > useful for you: > > - x86: /DSQLITE_DEFAULT_CACHE_SIZE=2000 /DSQLITE_DEFAULT_FOREIGN_KEYS=1 > /DSQLITE_DEFAULT_MEMSTATUS=0 /DSQLITE_DEFAULT_PAGE_SIZE=4096 > /DSQLITE_DEFAULT_TEMP_CACHE_SIZE=2000 /DSQLITE_THREADSAFE=0 > /DSQLITE_TEMP_STORE=2 /DSQLITE_ENABLE_FTS3 > /DSQLITE_ENABLE_FTS3_PARENTHESIS > /DSQLITE_ENABLE_FTS4 /DSQLITE_ENABLE_RTREE /DSQLITE_ENABLE_STAT3 > - x64: /DSQLITE_DEFAULT_CACHE_SIZE=4000 /DSQLITE_DEFAULT_FOREIGN_KEYS=1 > /DSQLITE_DEFAULT_MEMSTATUS=0 /DSQLITE_DEFAULT_PAGE_SIZE=8192 > /DSQLITE_DEFAULT_TEMP_CACHE_SIZE=4000 /DSQLITE_THREADSAFE=0 > /DSQLITE_TEMP_STORE=2 /DSQLITE_ENABLE_FTS3 > /DSQLITE_ENABLE_FTS3_PARENTHESIS > /DSQLITE_ENABLE_FTS4 /DSQLITE_ENABLE_RTREE /DSQLITE_ENABLE_STAT3 > > Both use: > > - Full Optimization (/Ox) > - (Inlining) Any Suitable (/Ob2) > - (Enable Intrinsic Functions) Yes (/Oi) > - Favor fast code (/Ot) > - Use MFC in a Static Library > > Everything is always in my Dropbox: > https://www.dropbox.com/sh/ecyzbn5kz4nf7ft/JHGD62iezx > > > > *Jonas Malaco Filho* > > > > 2012/5/24 Simon Slavin <slav...@bigfraud.org> > > > > > On 24 May 2012, at 11:49pm, Nick <eveningn...@gmail.com> wrote: > > > > > The sizes of the executable files are almost identical - there's a few > > > kilobytes difference. > > > I have attached the original (downloaded from sqlite.org) sqlite3.exe, > > > a compiled-by-myself sqlite3console.exe. And the source code. > > > > Attachments don't work on this list (we don't want everyone sending us > > their homework) but I hope the information you've provided gives someone a > > hint about what's going on. > > > > Simon. > > _______________________________________________ > > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
