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