You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Uwe Gerger <Uw...@bmw.de> on 2003/06/15 16:01:30 UTC
Performance tips for cocoon2.0.x required for large data amounts
Hello,
I use cocoon 2.0.4 for generating reports based on a Oracle databse and
also using XSLT to tramsform the data. For some reports I retrieve more
the 30000 records from the database. To tramsform them in a excel-report
it takes more then 45 minutes.
What performance improvements can be done in cocoon?
Thanks in advance
Uwe
--
Uwe Gerger _/_/_/ _/ _/ _/ _/
BMW AG, TG-53 IT-Technologie _/ _/ _/_/_/_/ _/ _/
80788 Muenchen _/_/_/ _/ _/ _/ _/ _/ _/
Tel: +49 89 382 35687 _/ _/ _/ _/ _/_/_/_/
Fax: +49 89 382 49040 _/_/_/ _/ _/ _/ _/
mailto:Uwe.Gerger@bmw.de
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org
RE: Performance tips for cocoon2.0.x required for large data amounts
Posted by Geoff Howard <co...@leverageweb.com>.
1) http://cocoon.apache.org/2.0/performancetips.html
2) caching, if it is an option
- http://wiki.cocoondev.org/Wiki.jsp?page=WritingForCacheEfficiency
- caching database results is not implemented by default in cocoon so
you'll need to write your own code to interface with the cocoon
cache system. See the page above, and the xsp cache examples.
3) consider ways to offload heavy processing from your xslt. you can
often do this in ways that don't mix presentation with logic.
4) this is mentioned in the doc at #1, but consider pre-generating these
reports (or portions of them) via command line cocoon.
5) And of course, buy beefy hardware! If that's not possible, at least
make sure your machine is not "thrashing" - spending time paging
memory out to disk and back in because it is memory starved. Also,
if you have the memory available on the machine, make sure you have
allocated it for use by the jvm when you start up your servlet
container.
HTH,
Geoff Howard
> -----Original Message-----
> From: Uwe Gerger [mailto:Uwe.Gerger@bmw.de]
> Sent: Sunday, June 15, 2003 10:02 AM
> To: cocoon-users@xml.apache.org
> Subject: Performance tips for cocoon2.0.x required for large data
> amounts
>
>
> Hello,
> I use cocoon 2.0.4 for generating reports based on a Oracle databse and
> also using XSLT to tramsform the data. For some reports I retrieve more
> the 30000 records from the database. To tramsform them in a excel-report
> it takes more then 45 minutes.
>
> What performance improvements can be done in cocoon?
>
> Thanks in advance
> Uwe
> --
> Uwe Gerger _/_/_/ _/ _/ _/ _/
> BMW AG, TG-53 IT-Technologie _/ _/ _/_/_/_/ _/ _/
> 80788 Muenchen _/_/_/ _/ _/ _/ _/ _/ _/
> Tel: +49 89 382 35687 _/ _/ _/ _/ _/_/_/_/
> Fax: +49 89 382 49040 _/_/_/ _/ _/ _/ _/
> mailto:Uwe.Gerger@bmw.de
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org