cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Robin Green" <gree...@hotmail.com>
Subject Re: ESQL and max-rows / skip-rows attributes
Date Tue, 23 Jan 2001 19:56:26 GMT
Werner Guttmann <Werner.Guttmann@msdw.com> wrote:
>Hi,
>
>I just had a look at the esql logicsheet of the 1.8.1 distribution to
>see how the <esql:max-rows> and <esql:skip-rows> attributes have been
>implemented.
>
>By looking at the code, it seems that for each execution of a
><esql:connection> the underlying query is always executed. Only during
>insertion of the sql results into the current DOM tree the
><esql:max-rows> and <esql:skip-rows> are used to define the range of
>records (skip-rows, skip-rows + max-rows] to be inserted.
>
>As this can easily get very expensive for complex queries, I am looking
>for an alternative way to 'cache' long results as returned by the esql
>logicsheet. If I were to do the same using e.g. JSP with Struts as the
>framework, one would simply put some bean holding the results into an
>HTTPSession and use the JSP to render fragments of this (e.g. the third
>25 records) to HTML.
>
>How would one achieve the same in Cocoon ? Could one simply store the
>XML as returned by the esql logicsheet to a session (as text, as DOM,
>etc ??) and on a subsequent request simply get a fragment of the stored
>xml document and insert it into the current page's DOM document ?

Yes, that should work fine. Cocoon 1 only does basic caching, leaving the 
rest up to you to control.



_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


Mime
View raw message