[opencms-dev] CmsJspNavBuilder->getSiteNavigation

[fhsubscriptions at componio.net]

Hi Thomas,

when we have a large number of DB requests or large data sets with many
joins we introduce a XML data type (consider this to be like a DB view)
and a singleton to handle the data.
The singleton "knows" when and how to update the data if it subscribes
itself to the OpenCms publishing event queue. Further you can use
concepts like combination and inheritance if the singletons are cleverly
thought out.

The downside is another hit on the heap but the corresponding DB
solution will have this problem as well (@Alex no streaming interface
:-)). The upside is that you can read and manipulate the data with
standard OpenCms mechanics (such as collectors, search, ...) without
having the need to write/use an OR mapper for the custom DB table(s).


Sincerely



\Fabian

Am 26.02.14 12:36, schrieb 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
>
>
>
> _______________________________________________
> 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
>
>
>