[Zope] Caching Catalog results for performance

[Small Business Services]

Zcatalog is pretty quick with the built-in caching.  Have you encountered
performance problems?  Have you tried tweaking the cache settings? (the
default cache size is pretty small, if RAM is not a problem, increase the
'Target number of objects in memory per cache' setting which is located in
Control Panel - Database Management - Cache Parameters - for our system we
use a setting of 10000 which gives us pretty good performance for a zcatalog
containing about 700,000 items).

Jonathan


----- Original Message -----
From: "Heimo Laukkanen" <huima at iki.fi>
To: <zope at zope.org>
Sent: February 24, 2004 9:30 AM
Subject: [Zope] Caching Catalog results for performance


> Hi all,
>
> I am working on a portal where we want to cache some catalog queries per
> person for some time, from few seconds to few minutes - since the data is
> something that does not need to be updated every single pageload, but can
> be cached for seconds - sometimes even for multiple minutes per user.
>
> What we have been thinking so har is this:
>
> - Cached data will be stored in ram in Temporary folder in simple object
> that will store data in it's attribute. Memory is not an issue for now,
> and if it will become - cached data will be stored in ZODB, rather than
> kept all the time in the memory.
>
> - Since brains are unpickleable we will create a dictionary from the brain
> by getting schema from the Catalog and then just getting each
> metadatafield from the brain
>
> Has anyone else done similar or thought about doing it?
>
> --
> -huima
>
>
> _______________________________________________
> Zope maillist  -  Zope at zope.org
> http://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://mail.zope.org/mailman/listinfo/zope-announce
>  http://mail.zope.org/mailman/listinfo/zope-dev )