Re: Determining when a cached item is out of date

2003-01-17 Thread Honza Pazdziora
On Thu, Jan 16, 2003 at 04:40:07PM -0600, Christopher L. Everett wrote: > > But again, there is the issue of mapping changed data onto dependent > pages. I guess one way to do that is to track which database rows > appear in which pages in the database. Since typically I do several > database op

Re: Determining when a cached item is out of date

2003-01-16 Thread Perrin Harkins
Christopher L. Everett wrote: I see where one could combine polling and invalidation, for instance by having empty files representing a page that get touched when the data for them go out of date. More commonly you would combine TTL with invalidation. You use invalidation for the simple stuff,

Re: Determining when a cached item is out of date

2003-01-16 Thread Christopher L. Everett
Perrin Harkins wrote: Christopher L. Everett wrote: But I haven't been able to wrap my skull around knowing when the data in Mysql is fresher than what is in the cache without doing a major portion of the work needed to generate that web page to begin with. There are three ways to handle cache

Re: Determining when a cached item is out of date

2003-01-16 Thread Perrin Harkins
Christopher L. Everett wrote: But I haven't been able to wrap my skull around knowing when the data in Mysql is fresher than what is in the cache without doing a major portion of the work needed to generate that web page to begin with. There are three ways to handle cache synchronization: 1) Ti

Re: Determining when a cached item is out of date

2003-01-16 Thread Ed
On Thu, Jan 16, 2003 at 06:33:52PM +0100, Honza Pazdziora wrote: > On Thu, Jan 16, 2003 at 06:05:30AM -0600, Christopher L. Everett wrote: > > > > Do AxKit and PageKit pay such close attention to caching because XML > > processing is so deadly slow that one doesn't have a hope of reasonable > > re

Re: Determining when a cached item is out of date

2003-01-16 Thread Honza Pazdziora
On Thu, Jan 16, 2003 at 06:05:30AM -0600, Christopher L. Everett wrote: > > Do AxKit and PageKit pay such close attention to caching because XML > processing is so deadly slow that one doesn't have a hope of reasonable > response times on a fast but lightly loaded server otherwise? Or is > it bec

Determining when a cached item is out of date

2003-01-16 Thread Christopher L. Everett
I'm moving into the XML space and one of the things I see is that XML processing is very expensive, so AxKit, PageKit, et al make extensive use of caching. I'm keeping all of my data in a MySQL DB with about 40 tables. I'm pretty clear about how to turn that MySQL data into XML and turn the XML i