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