> 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
