Hi SQLite users and devs, I have an application using SQLite which stores XZ-compressed blobs of JSON from the Twitter API to minimize disk usage. 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. For example:
In the above query, unxz is run three times, even though content doesn't change within the same row. Is there a way to tell SQLite to only run a function once per row of results? I looked into https://sqlite.org/c3ref/get_auxdata.html, but it appears that metadata is only stored for compile-time constants. Thanks, Rob -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users