[Zope-dev] catalog performance: query plan

Alan Runyan runyaga at runyaga.com
Mon Oct 27 12:32:21 EDT 2008


I agree with Tres.  A lot more can be done with Indexes and Catalog
without caching.

The most exiciting development in Catalog optimizations comes out
Jarn.  Helge Tesdal (iirc) did a buncha work  at a RDBMS company when
he was in college.  He has a protoype of a query plan for ZCatalog.

http://www.jarn.com/blog/catalog-query-plan

I would like to ask Roche and others to look at the Query Plan.

Caching is a total PITA because invalidation machinery becomes
overwhelming complex and unwieldly quickly in production.

-- 
Alan Runyan
Enfold Systems, Inc.
http://www.enfoldsystems.com/
phone: +1.713.942.2377x111
fax: +1.832.201.8856


More information about the Zope-Dev mailing list