Author: dkuleshov Date: 2011-12-07 04:12:55 -0500 (Wed, 07 Dec 2011) New Revision: 5275 Modified: jcr/trunk/exo.jcr.docs/exo.jcr.docs.developer/en/src/main/docbook/en-US/modules/jcr/configuration/jdbc-data-container-config.xml Log: EXOJCR-1668: added info about statistic collection Modified: jcr/trunk/exo.jcr.docs/exo.jcr.docs.developer/en/src/main/docbook/en-US/modules/jcr/configuration/jdbc-data-container-config.xml =================================================================== --- jcr/trunk/exo.jcr.docs/exo.jcr.docs.developer/en/src/main/docbook/en-US/modules/jcr/configuration/jdbc-data-container-config.xml 2011-12-07 09:09:05 UTC (rev 5274) +++ jcr/trunk/exo.jcr.docs/exo.jcr.docs.developer/en/src/main/docbook/en-US/modules/jcr/configuration/jdbc-data-container-config.xml 2011-12-07 09:12:55 UTC (rev 5275) @@ -273,11 +273,12 @@ $ db2stop $ db2start</programlisting></para> </listitem> + <listitem> - <para>Be aware, when using RDBMS for reindexing need to run - "RUNSTATS ON TABLE &lt;scheme&gt;.&lt;table&gt; WITH DISTRIBUTION - AND INDEXES ALL" for JCR_SITEM (or JCR_MITEM) and JCR_SVALUE (or - JCR_MVALUE) tables.</para> + <para>Be aware, when using RDBMS you need to run "RUNSTATS ON TABLE + &lt;scheme&gt;.&lt;table&gt; WITH DISTRIBUTION AND INDEXES ALL" for + JCR_SITEM (or JCR_MITEM) and JCR_SVALUE (or JCR_MVALUE) + tables.</para> </listitem> </itemizedlist> </section> @@ -293,11 +294,19 @@ consistency in your use-case. This dialect is only dedicated to the community.</para> </listitem> + + <listitem> + <para>MySQL relies on collected statistics for keeping track of data + distribution in tables and for optimizing join statements, but you + can manually call '<ulink + url="http://dev.mysql.com/doc/refman/5.0/en/analyze-table.html"... + to update statistics if needed.</para> + </listitem> </itemizedlist> </section> <section> - <title>PostgresSQL configuration</title> + <title>PostgreSQL configuration</title> <itemizedlist> <listitem> @@ -305,6 +314,14 @@ "enable_seqscan" to "off" or "default_statistics_target" at least "50"</para> </listitem> + + <listitem> + <para>Though PostgreSQL server performs query optimization + automatically, you can manualy call '<ulink + url="http://www.postgresql.org/docs/8.1/static/sql-analyze.html"... + command to recollect statistic data which can influence the + performance.</para> + </listitem> </itemizedlist> </section> @@ -321,8 +338,50 @@ documentation page "Selecting a SQL Server Collation" <ulink url="http://msdn.microsoft.com/en-us/library/ms144250.aspx">... </listitem> + + <listitem> + <para>MS SQL DB server's optimizer automatically processes queries + to increase performance. Optimization is based on statistical data + which is collected automatically, but you can manually call <ulink + url="http://en.wikipedia.org/wiki/Transact-SQL">Transact-SQL... + command '<ulink + url="http://msdn.microsoft.com/en-us/library/ms187348.aspx">... + STATISTICS</ulink>' which in very few situations may increase + performance.</para> + </listitem> </itemizedlist> </section> + + <section> + <title>Sybase configuration</title> + + <itemizedlist> + <listitem> + <para>Sybase DB Server optimizer automatically processes queries to + increase performance. Optimization is based on statistical data + which is collected automatically, but you can manually call <ulink + url="http://en.wikipedia.org/wiki/Transact-SQL">Transact-SQL... + command '<ulink + url="http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@... + statistics</ulink>' which in very few situations may increase + performance.</para> + </listitem> + </itemizedlist> + </section> + + <section> + <title>Oracle conficuration</title> + + <itemizedlist> + <listitem> + <para>Oracle DB automatically collect data statistics to optimize + performance of queries, but you can manually call '<ulink + url="http://docs.oracle.com/cd/B13789_01/server.101/b10759/statement... + command to start collecting statistics immediately which may improve + performance.</para> + </listitem> + </itemizedlist> + </section> </section> <section>