Re: Caching results of SQL Queries?

2002-11-15 Thread Jeremy Quinn
On Friday, Nov 15, 2002, at 17:43 Europe/London, Justin Fagnani-Bell wrote: If you're doing the SQL queries in a custom component (generator, transformer) you can use Cocoon's caching system. Have you class implement Cachable, and in the generateValidity() method you can return an object wi

Re: Caching results of SQL Queries?

2002-11-15 Thread Justin Fagnani-Bell
Jeremy, If you're doing the SQL queries in a custom component (generator, transformer) you can use Cocoon's caching system. Have you class implement Cachable, and in the generateValidity() method you can return an object with the last modification date of the database. see : http://xml.apach

Re: Caching results of SQL Queries?

2002-11-15 Thread Christian Haul
On 14.Nov.2002 -- 11:37 AM, Jeremy Quinn wrote: > Dear All, > > I have a set of related Tables in MySQL, which are used to build part > of a site I am working on. > > We use SQL because of the related nature of the data, rather than any > great need for dynamics. > > My SQL queries are broken

Caching results of SQL Queries?

2002-11-14 Thread Jeremy Quinn
Dear All, I have a set of related Tables in MySQL, which are used to build part of a site I am working on. We use SQL because of the related nature of the data, rather than any great need for dynamics. My SQL queries are broken down into 'components' which are CIncluded into my documents from