On 27 Oct 2008, at 13:10, Roché Compaan wrote:
Improving the performance of indexes is really really hard. In this case I really don't think caching is a band-aid, it is a good solution. Even with optimised indexes, you will find that you need caching to get reasonable performance if you have a catalog with close to a million or more documents indexed. Given a large enough catalog, I would argue that caching is equally as necessary as having a large cache for a ZEO client.
But caches expire and results get invalidated, and therefor we should continue to optimise indexes. With some help we should be able to contribute at this level too.
-- Roché Compaan Upfront Systems http://www.upfrontsystems.co.za
Thanks to you and everyone else working on these sometimes thankless performance improvements. --r Russ Ferriday - Topia Systems - Open Source content management with Plone and Zope russf@topia.com - office: +44 2076 1777588 - mobile: +44 7789 338868 - skype: ferriday