On Fri, 5 Jan 2018 12:02:21 -0800 Jens Alfke <j...@mooseyard.com> wrote:
> > On Jan 5, 2018, at 11:25 AM, r...@hoelz.ro wrote: > > > > … My unxz function is a little slow, and I've noticed that if I > > specify the function several times in a query, it gets run multiple > > times, even though it's deterministic. … Is there a way to tell > > SQLite to only run a function once per row of results? > > Not currently. There was a long-ish email thread about that here last > September, with subject "Common subexpression optimization of > deterministic functions”. I don’t think there was any resolution, > just that it’s an optimization that hasn’t been implemented yet. > > —Jens > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users Thanks for letting me know about the thread, Jens - I did a cursory search of the archives but I must've been using the wrong keywords! I'll read up on that. -Rob _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users