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. Also there's import tables dump (import tables are also very similar for both executables). I hope you can see the difference in the speed:
http://dl.dropbox.com/u/74970714/Custom%20built%20SQLite3.exe%20Performance%20problem.rar There is also a database file. but it is quite large (71 Mb). You can download it here, to be able to test the SQL query: http://dl.dropbox.com/u/74970714/database.sqlite Thanks to anyone who can help! 2012/5/25 Simon Slavin <slav...@bigfraud.org>: > > On 24 May 2012, at 11:13pm, Nick <eveningn...@gmail.com> wrote: > >> In my initial message I described some proof-of-concept that I've done. >> >> I downloaded sqlite3.exe (An SQLite command line tool) from the >> SQLite's website. I executed my query and I had to wait 4 seconds for >> it to complete. >> >> Then I downloaded sqlite3.c, sqlite3.h and shell.c, compiled them >> altogether (and got again the command line tool, but now i've built it >> by myself using Visual Studio) and executed the same query. It took 15 >> seconds this time. > > I'm very sorry I missed that. I have now re-read your original post. > > Can you compare the size of the two executable files for us ? Are the > various versions you're compiling (I understand you've tried several > different compilation options) all definitely bigger than the one supplied on > the SQLite site ? It might give us something to investigate. Also, I don't > know how to do this under Windows, but do you have a way to check whether the > versions made by Visual Studio address any DLLs or other libraries ? > > 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
