On Mon, Sep 08, 2003 at 02:44:59PM +1000, Shawn Day wrote:
Hi Paul,
You'll get more responses if you keep the discussion on the mailing list.
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)
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@zope.org [mailto:zope-bounces@zope.org] On Behalf Of Paul Winkler Sent: Monday, September 08, 2003 3:34 PM To: Shawn Day Cc: zope@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@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 )
On Mon, Sep 08, 2003 at 04:15:23PM +1000, Shawn Day wrote:
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?
should be ok... and in fact now that i think about it, you'd probably get an error if it wasn't one of your indexes.
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.
Too bad, you'd likely get a good speed boost from 2.6.2 or 2.7. And I found that moving from 2.5 to 2.6 was painless. (2.7 might be a bit more work to set up; there's a new config & startup system.) One other thing to check: if any of your indexes are for dates, use a DateINdex rather than FieldIndex. You'll save some memory that way and it might affect your RAMCacheManager (assuming you have one). There was a recent thread about this on zope-cmf list. I wouldn't guess that this directly affects the speed of searching, but it does affect memory consumption. Not sure. (Of course, memory consumption can affect speed drastically if you're near the box's physical RAM limit and push it over the edge into swapping heavily to disk...) I'm out of other ideas at this point. Anybody else? -- Paul Winkler http://www.slinkp.com Look! Up in the sky! It's DOOD DEATH! (random hero from isometric.spaceninja.com)
participants (2)
-
Paul Winkler -
Shawn Day