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 dent in this. ZCatalog loads search results metadata into memory on demand. This saves alot of time if your search results page only shows perhaps 10 out of 1000 hits, because only 10 sets of metadata have to be loaded. It sounds like you have some code which is touching all 1000. Are you performing manual sorting or filtering on the results set?