cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christian Haul <>
Subject Re: big ESQL performance problem
Date Tue, 04 Mar 2003 15:25:09 GMT
On 04.Mar.2003 -- 04:08 PM, Leszek Gawron wrote:
> 2. Same query run by cocoon:
> INFO    (2003-03-04) 16:03.13:573   [access]
> (/romes/data-old/contractors-offline-bug) Thread-6/CocoonServlet:
> 'romes/data-old/contractors-offline-bug' Processed by Apache Cocoon 2.1-dev in
> 9.93095 minutes
> (this query is much bigger then the previous one I tested it on)
> My sitemap entries are simple: match, generate type="serverpages", serialize
> to xml. nothing more.
> News from just a while ago: I've been monitoring CPU usage. It's not cocoon
> which consumes most of CPU while fetching these data but pervasive. So I think
> you should consider that esql performs too much database interaction (from
> what I saw it does not cache metadata information and fetches it with every
> row. Is there a way to omit esql use metadata ?

Off my head esql does not care much about metadata. However,
retrieving strings might be a problem since we try to have it
one-size-fits-all and auto-magically do clobs and stuff as well. Would
be interesting to know if e.g. <esql:get-object/> does a better job.

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

View raw message