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
