[Zope] Major problems with slow catalog queries

[Toby Dickenson]

On Friday 13 Sep 2002 1:01 pm, Lea Smith wrote:

> Have used the product callprofiler and found 90% of
> the page creation time is more often than not taken up
> by the script which queries the catalog and returns
> the catalog results. The script does nothing else.
> This time generally varies between 8 to 30 seconds,
> but sometimes as long as 5 minutes!

There have been some speedups in 2.6, but nothing that will make a big de=
nt in=20
this.

ZCatalog loads search results metadata into memory on demand. This saves =
alot=20
of time if your search results page only shows perhaps 10 out of 1000 hit=
s,=20
because only 10 sets of metadata have to be loaded.

It sounds like you have some code which is touching all 1000. Are you=20
performing manual sorting or filtering on the results set?