I tried defining "SQLITE_TEMP_STORE 2" as well. Unfortunately it doesn't influence the speed much, in my case...
2012/5/25 Jonas Malaco Filho <jonasmalacofi...@gmail.com>: > Why TEMP_STORE=1 (file by default) and not TEMP_STORE=2 (memory by default)? > > *Jonas Malaco Filho* > > 2012/5/24 Simon Slavin <slav...@bigfraud.org> > >> >> On 24 May 2012, at 8:59pm, Nick <eveningn...@gmail.com> wrote: >> >> > So why does a prebuilt, downloaded from the sqlite website, command >> > line tool takes only 4 seconds, while the same tool, built by me, >> > takes 4 times longer time to execute? >> >> I'm wondering whether the speed increase is related to figuring out the >> parameters in the command. Purely out of interest, and not because I know >> it's faster, have you tried executing the query using sqlite3_exec() rather >> than _prepare(), _step(), _finalize() ? Don't do a lot of reworking of >> your code unless it turns out to be faster. >> >> 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