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.apache.org/cocoon/userdocs/concepts/caching.html
and the API docs for Cachable and CacheValidity.
-Justin
On Thursday, November 14, 2002, at 03: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 down into 'components' which are CIncluded into my documents from internal pipelines. Usually there are several components that use SQL queries in each document. (It is done this way to isolate the implementation of components from their useage as well as from the main sitemap).
The data seldom changes ..... is there any way I can force the internal pipelines to cache, without using the tricks like browser caching via the 'expires' header on the external pipeline?
Thanks for any suggestions.
regards Jeremy
--------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
