On 7 Nov 2017, at 11:12pm, Jens Alfke <j...@mooseyard.com> wrote:

> On Nov 7, 2017, at 2:39 PM, Keith Medcalf <kmedc...@dessus.com> wrote:
>> What advantage does your third-level (application) cache provide that is not 
>> provided by the two lower level caches?
> You’re being presumptuous here. It’s pretty common for presentation-level 
> data to be very expensive to recompute; a common example is partial or full 
> web pages. Rendering image, like graphs, can also be expensive. Or hey, how 
> about the results of a complex SQL query?

It’s caching at two different levels.  The level Keith is talking about happens 
when you submit a SQL query and cache the data retrieved.  The level Jens is 
talking about happens when you submit a SQL query, process the data, then cache 
the results of the processing.

And it’s all highly dependent on the hardware, the amount of data and the type 
of processing.  And we don’t know whether the OP did premature optimisation.  
So let’s forget this threadlet until and unless we have relevant data.

sqlite-users mailing list

Reply via email to