On the top menu we have 6 menu items end we have only one level below that have in average 5 items...
That's no so much. I'm wondering about the need to access the DB. Most of the accesses to the site are done as guest. Usually in this case the menu is the same from page to page. Is it not possible to cache this information? Here I'm made a test (it is ugly but informative):I force the system to use a hardcoded menu and it really increase the performance. But it is not doable in reality. What do you thinks ? ? Thanks for all the information you provide .. Benjamin L�onard Intrasoft Internationnal Currently at European Parliament -----Original Message----- From: Serge Huber [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 4:58 PM To: [EMAIL PROTECTED] Subject: RE: Performance and cache Another thought while I'm at it : how many calls to getAbsoluteContainerList do you have for a single page ? Maybe the easiest way to resolve the problem is to reduce these calls. For example if you're displaying a navigation menu this would just mean reducing the number of displayed levels. Regards, Serge Huber. At 10:12 07.07.2004, you wrote: >I try this call : > >SELECT ctnid_jahia_fields_data, id_jahia_fields_data FROM jahia_fields_data >WHERE pageid_jahia_fields_data ORDER BY ctnid_jahia_fields_data, >rank_jahia_fields_data, id_jahia_fields_data ASC > >12 is a page id I retrieve : > > >0 118 >46 119 >46 119 >46 119 >46 120 >46 120 >46 120 >46 121 >46 121 >46 121 >46 122 >46 122 >46 122 >47 123 >47 123 >47 123 >66 170 >67 171 >68 172 >69 173 >70 174 >71 175 >72 176 >73 177 >74 178 >492 1155 >492 1156 >492 1157 >492 1158 >493 1159 >504 1179 > > >Is it normal that the same data are duplicated or is it our database that >is corrupted? > > >Benjamin L�onard >Intrasoft Internationnal >Currently at European Parliament > > >-----Original Message----- >From: Serge Huber [mailto:[EMAIL PROTECTED] >Sent: Tuesday, July 06, 2004 4:42 PM >To: [EMAIL PROTECTED] >Subject: Re: Performance and cache > > >Hi Benjamin, > >For each call to getAbsoluteContainerList there are mainly three DB requests : > >SELECT ctnid_jahia_fields_data, id_jahia_fields_data FROM jahia_fields_data >WHERE pageid_jahia_fields_data=? ORDER BY ctnid_jahia_fields_data, >rank_jahia_fields_data, id_jahia_fields_data ASC > >SELECT DISTINCT id_jahia_ctn_entries, listid_jahia_ctn_entries FROM >jahia_ctn_entries WHERE pageid_jahia_ctn_entries=? > >SELECT DISTINCT id_jahia_ctn_lists, parententryid_jahia_ctn_lists FROM >jahia_ctn_lists WHERE pageid_jahia_ctn_lists=? > >These preload the content for the page, in as little requests as possible >(previously every container and field was loaded with it's own SQL request >which was much slower). If possible I would therefore suggest trying to put >indexes on these tables for pageid loading. > >Regards, > Serge Huber. > >At 14:58 05.07.2004, Benjamin LEONARD wrote: > >Hello , > >We have serious performance problem So I try to find out what are the > >bottle neck. > > > >In the file main_menu.inc I find out this line :" JahiaContainerList > >linkContainerList = jData.containers().getAbsoluteContainerList( > >"linkContainer", topLink.getID() ); > > > > > >This line is call on every page for every first level menu item. On my dev > >server each time this is call it take between 250 and 1000 ms. I suppose > >there is a database access. > > > >Can you give me a way to decrease this! Can we enable a cache???? > > > >Benjamin L�onard > >Intrasoft Internationnal > >Currently at European Parliament > >- -- --- -----=[ serge.huber at jahia dot com ]=---- --- -- - >Jahia : A collaborative source CMS and Portal Server >www.jahia.org Community and product web site >www.jahia.com Commercial services company - -- --- -----=[ serge.huber at jahia dot com ]=---- --- -- - Jahia : A collaborative source CMS and Portal Server www.jahia.org Community and product web site www.jahia.com Commercial services company
