[Zope] very slow zcatalog

[Shawn Day]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.zope.org/pipermail/zope/attachments/20030908/07b375fe/attachment.htm