> 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