[Zope] ZCatalog query optimisation

Dieter Maurer dieter@handshake.de
Mon, 4 Nov 2002 21:28:18 +0100


Thierry Florac writes:
 > I have a quite big ZCatalog, on which I have to make several queries
 > including several indexes.
 > Is there any way to optimize such queries (query parameters order, index
 > types,...) ??
Usually, you should ask the indexes which give rise to small
result sets first, to keep the intermediate results small.

However, I fear, the current catalog searches indexes in a fixed
order. You cannot determine it from the outside.


Dieter