> 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! :)
Well, that's good, except I thought you couldn't get rid of objects?
> > 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?
Yes, but not with 1,000,000 objects (see
lib/python/ZCatalog/tests/testCatalog.py). It would be nice to have such a
> 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.
That sounds good! At least for the Catalog. Want to be a tester? ;-)
> > 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.
Still curious whether it's index dependent.
Zope-Dev maillist - [EMAIL PROTECTED]
** No cross posts or HTML encoding! **
(Related lists -