On wto, mar 04, 2003 at 04:25:09 +0100, Christian Haul wrote:
> 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.
while trying to test the esql:get-object I have run just this:
<esql:execute-query>
<esql:query>
SELECT * from kontrah</esql:query>
<esql:results>
<esql:row-results><a></a></esql:row-results>
</esql:results>
</esql:execute-query>
The execution time does not differ much from first case even though I do not do any
esql-getXXX.
ouzo
--
__
| / \ | Leszek Gawron // \\
\_\\ //_/ [EMAIL PROTECTED] _\\()//_
.'/()\'. Phone: +48(600)341118 / // \\ \
\\ // recursive: adj; see recursive | \__/ |
