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
