Re: Caching results of SQL Queries?

[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 with the last modification date of the database.


OK, so you suggesting I could extend something like SQLTransformer to 
make a CacheableSQLTransformer.

Hmmm


regards Jeremy


-
Please check that your question  has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

Re: Caching results of SQL Queries?

[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.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. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

Re: Caching results of SQL Queries?

[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 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?

Perhaps the caching point stuff could help here? Michael?

Chris.
-- 
C h r i s t i a n   H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08

-
Please check that your question  has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

Caching results of SQL Queries?

[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 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. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>