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
D. Richard Hipp
drh at sqlite.org

Reply via email to