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
> 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.
Zope-Dev maillist - [EMAIL PROTECTED]
** No cross posts or HTML encoding! **
(Related lists -