shuber 2004/10/22 00:53:26 CEST
Modified files:
xdocs index.xml
Log:
Added documentation about database indices for improved performance.
Revision Changes Path
1.3 +13 -1 jahiadoctor/xdocs/index.xml
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahiadoctor/xdocs/index.xml.diff?r1=1.2&r2=1.3&f=h
Index: index.xml
===================================================================
RCS file: /home/cvs/repository/jahiadoctor/xdocs/index.xml,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- index.xml 21 Oct 2004 18:22:44 -0000 1.2
+++ index.xml 21 Oct 2004 22:53:26 -0000 1.3
@@ -1,4 +1,4 @@
-<?xml version="1.0" encoding="UTF-8"?>
+<?xml version="1.0" encoding="UTF-8"?>
<document>
<properties>
@@ -75,5 +75,17 @@
]]></source>
</p>
</section>
+ <section name="Performance">
+ <p>
+ In order to speed up some of the checks, it is highly recommended to add the
+ following indexes to the database if they don't already exist :
+<source>
+CREATE INDEX jahia_ctnlists_prop_index1 ON jahia_ctnlists_prop
(name_jahia_ctnlists_prop);
+CREATE INDEX jahia_ctnlists_prop_index2 ON jahia_ctnlists_prop
(value_jahia_ctnlists_prop);
+CREATE INDEX jahia_ctn_lists_index5 ON jahia_ctn_lists (rights_jahia_ctn_lists);
+CREATE INDEX jahia_sites_index1 ON jahia_sites (rights_jahia_sites);
+</source>
+ </p>
+ </section>
</body>
</document>
