On Fri, 5 Jan 2018 12:02:21 -0800 Jens Alfke <[email protected]> wrote:
> > On Jan 5, 2018, at 11:25 AM, [email protected] 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 > [email protected] > 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
