On 1/5/18, r...@hoelz.ro <r...@hoelz.ro> wrote: > 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: >
Your example did not go through. Please resend. Use plain-text email for best results. > > > 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 > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users