On Thu, Apr 3, 2014 at 4:10 AM, Kevin Xu <accol...@gmail.com> wrote: > I have put up my insertion code here: http://pastebin.com/yjRW2mh3
As mentioned by Stephan Beal, use SQLITE_STATIC instead of SQLITE_TRANSIENT for your text/blob binding. As long as the memory buffer you are binding stays valid and unchanged until the sqlite3_step() call, which is the case I believe, then using SQLITE_STATIC prevents SQLite from making copies of all those strings/blobs. You might gain a few %s from this alone. --DD _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
