[development] Caching, caching, caching...

[Larry Garfield]

On Saturday 22 July 2006 12:57, Dries Buytaert wrote:

> > I really like LRU conceptually, but I don't know how we'd implement
> > it.  If
> > done in the database, we'd have to write the last-access-time back
> > to the
> > database each time an alias is accessed, doubling the number of
> > queries
> > (unless someone know of a portable update-on-access field in SQL?).
>
> You'd only to that once in a while ... like, at most once every 10
> minutes, you'd update the 'frequency counter' (or whatnot).

And otherwise you'd keep it where?

-- 
Larry Garfield			AIM: LOLG42
larry at garfieldtech.com		ICQ: 6817012

"If nature has made any one thing less susceptible than all others of 
exclusive property, it is the action of the thinking power called an idea, 
which an individual may exclusively possess as long as he keeps it to 
himself; but the moment it is divulged, it forces itself into the possession 
of every one, and the receiver cannot dispossess himself of it."  -- Thomas 
Jefferson