I try this call : SELECT ctnid_jahia_fields_data, id_jahia_fields_data FROM jahia_fields_data WHERE pageid_jahia_fields_data=12 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
