[Zope] Major problems with slow catalog querie

[Toby Dickenson]

On Thursday 19 Sep 2002 1:34 pm, Lea Smith wrote:
> I have also found that the catalog becomes very
> sluggish after a 'find and catalog' to catalog the
> 10,500 items. It takes 10 mins for the catalog to
> return with the 'catalog' tab listing the cataloged
> items. It takes a further 10 mins before the python
> process drops its usuage of the processor from 90-95%
> down to 0-10%. From this point on, the catalog takes
> 40-45 seconds to return found items using the site
> search form. Restarting Zope brings the catalog back
> to the 1.5-5 seconds I had achieved previously.

Using Zope 2.5.x ? This sounds like a typical symptom caused by excessive=
=20
memory pressure on the ZODB object cache. You are probably seeing zope me=
mory=20
usage increase too?

2.6.x has a redesigned cache that shouldnt exhibit these problem.