Hello,
First of all have you indexed your database (or please check that you use ALL the indexes we suggest on the Jahia technical FAQ - we add new indexes from time to time)? You may also use the SQLProfiler in order to try to add new indexes if you are using Jahia from a specific manner (specific custom templates; specific use of the Jahia platform,...)
Else Jahia generates a lot of small simple SQL requests per page. Oracle is good at treating large complex SQL requests not thousands of small ones. So Oracle offers a lot of advantages (transactions; double committs;...) but it may be a bit overkill for Jahia. MySQL for example will go a lot more faster than Oracle for the kind of SQL requests Jahia is generating. So if Oracle is not a strict customer requirement, you may try to migrate to MySQL.
Always regarding the database you may try to use some JDBC cache in order to accelerate requests that are not cached by Jahia yet (... or two load-balanced databases in the back-end). Please check the open source C-JDBC driver to get more information about how you can do it: http://c-jdbc.objectweb.org/
On the JVM side, be sure that you allocate enough of memory. You may also try to use BEA JRockit which goes a bit faster than the SUN one (warning: we do not test Jahia on a daily basis on the BEA JRockit one, so you will have to test it a bit first).
Else if you have large pages with hundreds of containers, perhaps try to remove the action menus in edit mode in these large templates. The action menus check for each field on the page if they are locked or not, etc... By replacing them with simple edit buttons (without DHTML drop down menus) you will gain a lot of time (server side and browser side) in edit mode.
Finally if you still have some performance problems, you will need to run some Borland Optimizeit or some similar Java diagnose&monitoring tools to know exactly where the problem is (is it in Jahia? in your templates? elsewhere?)...
Cheers St�phane
At 13:29 06/09/2004, you wrote:
Hello,
I'm a bit stumped here with our site sometimes responding very slowly.
It seems especially slow when in edit mode and someones tries to modify things.
Nothing significant is found in the logs sofar.
So just displaying the page takes up no time at all.
I searched for a solution in the archive and it seems that just restarting tomcat brings solace?
Is there something else I could check?
Our environment: Jahia v4.04 Oracle 9 database Running on SunOS 5.9 Tomcat v4.1
Greetings, Philippe.
