Second: I already run vaccumdb once a day.
Third: I already created the special index for the most used queries/tables
My DB and Jahia area on the same computer.
These are the options tha I use in catalina.sh:
JAVA_OPTS="-Dfile.encoding=ISO-8859-1 -Xms128M -Xmx512M -server -XX:MaxHeapFreeRatio=70 -XX:MinHeapFreeRatio=40 -XX:+UseConcMarkSweepGC"
2005/10/8, Ghislain CUSSONNEAU <[EMAIL PROTECTED]>:
Fisrt : create the index from Jahia Clustering How-to documentation.
Second : Run the vaccumdb command (in postgresql bin folder) every day/week you made changes on your sites that optimize index usage
Third : run on the SQL log on postgresql to find which queries/tables are the most used and create special index for them.Is your DB and Jahia on the same computer ? What's the -Xms / -Xmx sizes in catalina.sh script for the JVM that's run Tomcat ?
Hi,
I'm using PostgreSQL 8.0.3, Slackware 10.0, j2ee 1.4.2, with 2 simultaneos users. I didn't set MaxHeapSize but I set MaxHeapFreeRatio=70 MinHeapFreeRatio=40. I'm using basicly portlets, but even the pages like "New User Registration" (pure CMS) spent 10 seconds, or more, to open.
--
Márcio Ferreira
Garimpar.com - Informação é tudo!!!
Garimpar.com - Information is everything!!!
Tel: 55 (13) 3216-2270 Ramal 202
Rua do Comércio 44 sala 02
Centro - Santos - SP - Brazil2005/10/7, Stéphane Croisier <[EMAIL PROTECTED]>:Could you send me any tips to get a better performance?http://www.dell.com/
;-)
No more seriously, we need more details about your environement in order to help you (OS; DB; ...) + Jahia config (JVM used; Max heap size; nb of pages; nb of simultaneous users; usage (CMS or portlets?)...)
/SC
At 22:46 06/10/2005, you wrote:
Hi,
I have Jahia running on my server (AMD Duron 1.5Ghz, 1GB RAM) and only one virtual site running on this Jahia.
I'm having problems of performance with this site, each page spent about 10 seconds, or more, to open. I already try the Fine Tunning Documentation from Jahia Documentation and didn't work.
Could you send me any tips to get a better performance?
Thank you,
--
Márcio Ferreira
Garimpar.com - Informação é tudo!!!
Garimpar.com - Information is everything!!!
Tel: 55 (13) 3216-2270 Ramal 202
Rua do Comércio 44 sala 02
Centro - Santos - SP - Brazil
--
Márcio Ferreira
Garimpar.com - Informação é tudo!!!
Tel: (13) 3216-1967 Ramal 202
Rua do Comércio 44 sala 02
Centro - Santos - SP
