Cocoon 1.8 slowness

[Benjamin Dixon <be...@arches.uga.edu>]

All,

Has anyone found that cocoon 1.8 is sometimes REALLY slow? I'm having,
what I would consider, simple XSP pages taking upwards of 85ms to load.
I tried restarting apache (and jserv), but it hasn't help. After I
initially made this page, I experienced no problems with speed, but now it
takes forever. Perhaps it has something to do with my XSP page, so I
include it below. According to the profiler, about 80 of the 85ms it
usually takes to load, are spent inside the XSP processor. Now, on some
occassions, I have had to select out large amounts of data (1000s of rows)
but here I have limited it to 10 rows with no difference in the results.


<?xml version="1.0"?>

<?cocoon-process type="xsp"?>
<?xml-logicsheet
href="resource://org/apache/cocoon/processor/xsp/library/sql/esql.xsl"?>

<xsp:page
  language="java"
  xmlns:esql="http://apache.org/cocoon/SQL/v2"
  xmlns:xsp="http://www.apache.org/1999/XSP/Core"
  xmlns:session="http://www.apache.org/1999/XSP/Session"
  create-session="true"
>

<page>
<esql:execute-query>
<esql:driver>oracle.jdbc.driver.OracleDriver</esql:driver>
<esql:dburl>jdbc:oracle:thin:@x.x.x.x:1521:xxxx</esql:dburl>
<esql:username>xxxxxx</esql:username>
<esql:password>xxxxxx</esql:password>
<esql:skip-rows-attribute>5</esql:skip-rows-attribute>
<esql:max-rows>10</esql:max-rows>
<esql:skip-rows>10</esql:skip-rows>
<esql:query>
   select distinct *
   from event_tab e,
        event_date_tab d
   where d.event_sref=e.sref
     and d.completed like 'yes'
     and zip like '30606'
</esql:query>
<esql:results>
   <event>
      <date>
         <day>
            <xsp:attribute name="start"><esql:get-string
column="timestamp"/></xsp:attribute>
         </day>
         <month></month>
         <year></year>
         <time><esql:get-string column="times"/></time>
      </date>
      <name>
         <esql:get-string column="event_name"/>
      </name>
      <headline>
         <esql:get-string column="headline"/>
      </headline>
      <summary>
         <esql:get-string column="short_desc"/>
      </summary>
      <description>
         <esql:get-string column="long_desc"/>
      </description>
      <image>
         <xsp:attribute name="src"><esql:get-string
column="image"/></xsp:attribute>
      </image>
      <template>
         <xsp:attribute name="style"><esql:get-string
column="template"/></xsp:attribute>
      </template>
      <address>
         <venue><esql:get-string column="venue"/></venue>
         <street1><esql:get-string column="address1"/></street1>
         <street2><esql:get-string column="address2"/></street2>
         <city><esql:get-string column="city"/></city>
         <state/>
         <zipcode><esql:get-string column="zip"/></zipcode>
      </address>
      <contact>
         <phone><esql:get-string column="phone"/></phone>
         <email><esql:get-string column="contact_email"/></email>
      </contact>
   </event>
</esql:results>
<esql:no-results>
 <error>no events were found</error>
</esql:no-results>
<esql:error-results>
 <message><esql:get-message/></message>
 <stacktrace><esql:get-stacktrace/></stacktrace>
</esql:error-results>
</esql:execute-query>
</page>
</xsp:page>