Thanks, nice and simple and helpful advice. RBS On 15 Dec 2015 1:45 pm, "Richard Hipp" <drh at sqlite.org> wrote:
> 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 > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
