[Zope-dev] ZCatalog, REQUEST, misc.

[Erik Enge]

On Thu, 17 May 2001, Chris McDonough wrote:

> I'd be curious to know how long a query that involves only a single
> field index takes, and how long a query that involves only a single text
> index takes... does each take a roughly equivalent amount of time?

I might be able to check that for you later tonight or during the
weekend.  What I did to solve my problems was to throw a couple of objects
around so that I now only have about 50k objects in the Catalog.

Boy it's fast.  I like! :)

> Or is one much faster than the other?  If one is not much faster than
> the other, it's a Catalog issue.  If one *is* much faster than the
> other, it's an Index issue.

Have you guys at DC not done testing on this?  Maybe we could set up a
"test-group" for each module in Zope, say Catalog/ZCatalog/SearchIndex,
that before each release, really beat the living shit about of it?  A bit
more coordinated.
 
> What's an acceptable query time for your application?  Are you sorting
> the results via sort_on?

Well, actually, the query time isn't that bad (now with only 50k objects),
it's all the problems a big result-set drags along with it that really
slows things down.