On 12/15/15, Bart Smissaert <bart.smissaert at gmail.com> wrote: > So I will need to use SQLITE_TRANSIENT then? >
Yes. Always use SQLITE_TRANSIENT, at least initially. All the other options are optimizations. Do not use the other options prematurely (that is to say, without first trying SQLITE_TRANSIENT and actually measuring that it presents performance problems) because premature optimization is the root of all evil (http://c2.com/cgi/wiki?PrematureOptimization). -- D. Richard Hipp drh at sqlite.org
