Toby Dickenson wrote at 2003-10-23 10:33 +0100:
On Thursday 23 October 2003 10:12, Bjorn Stabell wrote:
From: Toby Dickenson [mailto:tdickenson@geminidataloggers.com] Yes. The default of 4 threads is arguably too high. All my applications work better with 2 threads, and double the cache size (but still using the same total amount of memory)
I'm experimenting with that now. A catalog query that used to take 40-100 seconds with the default target number of objects in the cache now takes 1-2 seconds (or less) with the target number increased to 15,000. This 100x speed increase comes at the cost of using 0.5 GB of resident memory with 4 threads.
15k objects sounds like alot for a catalog query.
We observed that the "BTrees.IOBTree.IOBTree" records used for ZCatalog Metadata can be very large (our Metadata contains a "Description" field which often has several kb). -- Dieter