[Zope-Checkins] SVN: Zope/trunk/doc/CHANGES.rst Explain all those query plan changes in the changelog

Hanno Schlichting hannosch at hannosch.eu
Mon Aug 2 17:00:40 EDT 2010


Log message for revision 115389:
  Explain all those query plan changes in the changelog
  

Changed:
  U   Zope/trunk/doc/CHANGES.rst

-=-
Modified: Zope/trunk/doc/CHANGES.rst
===================================================================
--- Zope/trunk/doc/CHANGES.rst	2010-08-02 20:32:55 UTC (rev 115388)
+++ Zope/trunk/doc/CHANGES.rst	2010-08-02 21:00:40 UTC (rev 115389)
@@ -68,6 +68,21 @@
 Features Added
 ++++++++++++++
 
+- Merged the query plan support from both ``unimr.catalogqueryplan`` and
+  ``experimental.catalogqueryplan`` into ZCatalog. On sites with large number of
+  objects in a catalog (in the 100000+ range) this can significantly speed up
+  catalog queries. A query plan monitors catalog queries and keeps detailed
+  statistics about their execution. Currently the plan keeps track of execution
+  time, result set length and support for the ILimitedResultIndex per index for
+  each query. It uses this information to devise a better query execution plan
+  the next time the same query is run. Statistics and the resulting plan are
+  continuously updated. The plan is per running Zope process and not persisted.
+  You can inspect the plan using the ``Query Plan`` ZMI tab on each catalog
+  instance. The representation can be put into a Python module and the Zope
+  process be instructed to load this query plan on startup. The location of the
+  query plan is specified by providing the dotted name to the query plan
+  dictionary in an environment variable called ``ZCATALOGQUERYPLAN``.
+
 - Various optimizations to indexes _apply_index and the catalog's search
   method inspired by experimental.catalogqueryplan.
 
@@ -81,7 +96,7 @@
 
 - Added a new reporting tab to `Products.ZCatalog` instances. You can use this
   to get an overview of slow catalog queries, as specified by a configurable
-  threshold value. The reports are per running Zope process.
+  threshold value.
 
 - Warn when App.ImageFile.ImageFile receives a relative path with no prefix,
   and then has to assume the path to be relative to "software home". This



More information about the Zope-Checkins mailing list