[Zope] ZCatalog - OR'ing on different colums (indices)

[R. David Murray]

On Fri, 25 Aug 2000, Aleksander Salwa wrote:
> Is there any better method of OR'ing on differend indices in quering
> ZCatalog, then the method described in 'Advanced ZCatalog Searching'
> How-To:

One way that works well but only works if you always do the same
type of search (which it sounds like is true in your case) is to
create a method for all of the objects that returns the concatenation
of all of the data fields of intrest, and index that in the Catalog.
You then search on the field, and return the relevant documents.
Since the Catalog only stores word indexes and document indexes and not
the text itself, this is not as inefficient as it sounds.  It's
also a little more execution-time efficient (which is good for a
web ap) since you are effectively pre-computing the between-fields
OR portion of the search.

--RDM