Hi Michael, Kreith, Jonas, Thanks for your response. I just tried to launch the binary manually, and it worked very fast. I didn't figure out by myself that i should've tried to launch the application outside of Visual Studio (I was thinking that in "Release" mode VS doesn't slow down the execution by debugging instruments). Sorry for raising a dust with all this.
2012/5/25 Black, Michael (IS) <michael.bla...@ngc.com>: > Usng your sqlite3.exe > CPU Time: user 2.156250 sys 2.078125 > > Using your sqlite3.console.exe > CPU Time: user 1.375000 sys 0.140625 > > I'm afraid I don't see the problem since the pre-built is slower than your > executable for me. > > > Michael D. Black > Senior Scientist > Advanced Analytics Directorate > Advanced GEOINT Solutions Operating Unit > Northrop Grumman Information Systems > > > > From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on > behalf of Nick [eveningn...@gmail.com] > Sent: Thursday, May 24, 2012 5:49 PM > To: General Discussion of SQLite Database > Subject: EXT :Re: [sqlite] SQLite SELECT performance problem > > > 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 > _______________________________________________ > 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
