[Zope] very slow zcatalog

[Shawn Day]

Paul, I removed the sort_on='searchValue', and results are returned much
quicker if there are not many results to return. If there are lot of
results than it is still pretty slow.

The searchValue attribute is part of my index, so this shouldn't be a
factor should it?

The server where the site is being hosted is still running zope 2.5, I'm
pretty sure. Not a real lot I can do about this.


-----Original Message-----
From: zope-bounces at zope.org [mailto:zope-bounces at zope.org] On Behalf Of
Paul Winkler
Sent: Monday, September 08, 2003 3:34 PM
To: Shawn Day
Cc: zope at zope.org
Subject: Re: [Zope] very slow zcatalog

On Mon, Sep 08, 2003 at 02:44:59PM +1000, Shawn Day wrote:
> Hi Paul,

> Thanks for your reply. Yes I do have the all the attributes in my
> metadata. I display the title, address, phone number and email - if
they
> have one. 

OK... but what about this? (from your original message):

> sort_on='searchValue',

Sorting is usually the slowest part of zcatalog searches.
First, try removing this line, see if the search comes up faster. 
(maybe a lot faster.) If so, at least you have confirmed that the 
problem is sorting. 

If that's the problem, I'm suspicious of 'searchValue'. 
For sort_on, you should pass the name of one of your
catalog indexes.

> The page that has this search is actually on the directory page of our
> site. www.regionlink.com.au/Members if you would like to have a look.

yep, it's rather slow... but i can't tell much from looking at it.
I don't have your source code.

What version of Zope are you running? 2.6.1 or greater should do
zcatalog
sorts faster than previous zope versions, and 2.7 beta should be
faster still (I have not tried 2.7).
More details here:
http://zope.org/Members/Caseman/ZCatalog_for_2.6.1/view

-- 

Paul Winkler
http://www.slinkp.com
Look! Up in the sky! It's UNDULATING GUZZLING WEREWOLF!
(random hero from isometric.spaceninja.com)

_______________________________________________
Zope maillist  -  Zope at zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )