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