Hi there, I am a relative newbie to zope and have a question about the zcatalog. I have a directory filled with nearly 6000 Plone folders. Each of these folders holds information about a business in my town and they are contained in a zcatalog. The problem is that a search generally takes about 50 seconds. A search for a business can be done by Business Category, Business Type, Location, Keywords or a combination of any of these. The business category and business type are both keyword indexes, the location is a field index and the keywords is a text index. Results are sorted by a searchValue which is a field index. The query is shown below: tal:define="results python:here.businessCatalog(meta_type='Plone Folder', location_d=location, types=type, keywords=key_words, sub_types=sub_type, sort_on='searchValue', sort_limit=30)" In my attempts to speed this process up I have made sure the cache is large enough (8000) and have tried turning on subtransactions and setting the threshold to 10000. I am yet to taste success with this problem. If anyone can help me speed up the search I would be enormously greatful. If you would like to see the problem yourself you can at: www.regionlink.com.au <http://www.regionlink.com.au/> Shawn.
On Mon, Sep 08, 2003 at 12:20:30PM +1000, Shawn Day wrote:
If anyone can help me speed up the search I would be enormously greatful.
Hmm. In your results, what attributes do you display, and is any of it not represented in the portal_catalog's Metadata tab? If so, you'll be directly touching every object in the result set, and that can be slow.
you would like to see the problem yourself you can at: www.regionlink.com.au <http://www.regionlink.com.au/>
hmm, i only find a simple search form in which i can't seem to trigger this problem. I keep getting "no results found". What should I search for? -- Paul Winkler http://www.slinkp.com Look! Up in the sky! It's BRUCE LEE WITHOUT PANTS! (random hero from isometric.spaceninja.com)
Shawn Day wrote:
Hi there,
I am a relative newbie to zope and have a question about the zcatalog. I have a directory filled with nearly 6000 Plone folders. Each of these folders holds information about a business in my town and they are contained in a zcatalog. The problem is that a search generally takes about 50 seconds.
Are you shure that the problem is your query? I did a few searches and they came in at around 10 seconds. Perhaps you are generating too long lists? regards Max M
participants (3)
-
Max M -
Paul Winkler -
Shawn Day