Execution of page contained with number of sql queries problem

2002-12-03 Thread Triveni
Hi How do I redirect to another page in Cocoon other than map:redirect tag. If there are a number of sql queries in one xsp page, it is taking quite a long time to execute. Each sql query is in an 'if-else' condition, so actually all the queries need not be executed. At the most only

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

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.

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

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

RE: sql queries

2001-11-15 Thread Luca Morandini
/lmorandini/index.html - -Original Message- From: Ferran Urgell [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 9:28 AM To: [EMAIL PROTECTED] Subject: sql queries Hi Friends ! I would to know more about how to get queries results in

sql queries

2001-11-15 Thread Ferran Urgell
Hi Friends ! I would to know more about how to get queries results in xsl.. Where can I find information about this ? Thanks! FerranDo You Yahoo!? Find the one for you at Yahoo! Personals.