[Zope] Major problems with slow catalog queries

Toby Dickenson tdickenson@geminidataloggers.com
Fri, 13 Sep 2002 13:23:02 +0100


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?