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

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

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 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 function is a little > slow, and I've noticed that if I specify the function several

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

> 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