[opencms-dev] CmsJspNavBuilder->getSiteNavigation

[T.Kluge at t-systems.com]

Hi Kai,

we currently store the navtree object as a session variable. So in subsequent calls we don't need to call this function again.
But there is still the first call in a session and customers complain about this initial site-hang.

What I had in mind as I mentioned caching, was some kind of db caching as I get the feeling that there are numerous db requests to build the tree.

Regards,
Thomas


-----Ursprüngliche Nachricht-----
Von: opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org] Im Auftrag von Schliemann, Kai
Gesendet: Mittwoch, 26. Februar 2014 12:31
An: The OpenCms mailing list
Betreff: Re: [opencms-dev] CmsJspNavBuilder->getSiteNavigation

Hi Thomas,
If your are using this JSP only on one page of your entire website (e.g. for a sitemap), you can set the property cache=always on the JSP rendering the navigation.
If your are using this JSP on more than one page, you can set the property cache=uri on the JSP rendering the navigation.

When publishing a resource the cache will be completely emptied. So if you are having lots of publications during the day, the caching effect will be minimal.

HTH

Best regards
________________________________________     

Kai Schliemann
Dipl.-Wirtschaftsingenieur (FH)
Senior IT-Berater Softwareentwicklung
    
comundus GmbH
Schüttelgrabenring 3, D-71332 Waiblingen Zentrale      +49 7151-94421-10 Durchwahl  +49 7151-94421-20 Fax             +49 7151-94421-39 E-Mail k.schliemann at comundus.com Internet www.comundus.com
 
Geschäftsführer Klaus Hillemeier
Amtsgericht Stuttgart, HRB 264290
         
comundus ist ein Unternehmen der IT EXCELLENCE Group ________________________________________     

  

 

-----Ursprüngliche Nachricht-----
Von: opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org] Im Auftrag von Thomas Kluge
Gesendet: Mittwoch, 26. Februar 2014 10:47
An: opencms-dev at opencms.org
Betreff: [opencms-dev] CmsJspNavBuilder->getSiteNavigation

We have a solution which creates a complete navigation tree via
getSiteNavigation()
Unfortunately this function takes up to 12 seconds to complete.
We use an Oracle 12g database here. Testing with a local MySQL database revealed a creation time of 5 seconds. 

Is there any way to come around this. (caching, optimizing)?

regards,
Thomas


_______________________________________________
This mail is sent to you from the opencms-dev mailing list To change your list options, or to unsubscribe from the list, please visit http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev



_______________________________________________
This mail is sent to you from the opencms-dev mailing list To change your list options, or to unsubscribe from the list, please visit http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev