Derek Hohls dijo:
> I have an XSP page, containing ESQL; it works fine on my
> test machine which has a relatively small subset of data,
> but gives errors on the production machine with the full
> database.

OK. I suppose:
  1-You have 5,000+ rows in your current DB.
  2-The code in the XSP page works fine in your develpment machine.

Solution:
  1-Give more memory to Tomcat and Cocoon.

Detail:

  Suppose you can give 256 MB to Cocoon. then:

    1-For Tomcat, in TOMCAT_ROOT/bin/catalina.sh:

         CATALINA_OPTS='-Xmx256m'

       Also you need to tell Cocoon about that. In cocoon.xconf, search
for store-janitor:

<store-janitor logger="core.store.janitor">
     <parameter name="freememory" value="10000000"/>
     <parameter name="heapsize" value="256000000"/>
     <!-- How often shall the cleanup thread check memory -->
     <parameter name="cleanupthreadinterval" value="15"/>
     <!-- Indicates the thread priority of the cleanup thread -->
     <parameter name="threadpriority" value="5"/>
     <!-- How much percent of the elements of each registered Store shall
     be removed when low on memory. Default 10% -->
     <parameter name="percent_to_free" value="10"/>
  </store-janitor>

More recommendations:
  1- Upgrade to Tomcat 4.1.18

Finally Restart Tomcat! I hope it will help.

Best Regards,

Antonio Gallardo.



---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

Reply via email to