On Fri, 5 Jan 2018 15:04:16 -0500 Richard Hipp <d...@sqlite.org> wrote:
> 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 > > > > Here's the example: > select json_ref(unxz(content), '$.user.id'), json_ref(unxz(content), > '$.full_text) from archive where json_ref(unxz(content), > '$.full_text') like '%dogs%'; _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users