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

Shawn.