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 report.
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.