Re: [sqlite] Preventing a slow, determinstic function from running twice

On Fri, 5 Jan 2018 12:02:21 -0800 Jens Alfke wrote: > > 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

Re: [sqlite] Preventing a slow, determinstic function from running twice

On Fri, 5 Jan 2018 15:04:16 -0500 Richard Hipp wrote: > On 1/5/18, 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 > >

Re: [sqlite] Preventing a slow, determinstic function from running twice

On Fri, 5 Jan 2018 14:42:00 -0600 Rob Hoelz <r...@hoelz.ro> wrote: > 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, > > > >