#5: Query Optimizations
- Contents
by
Jonah Bossewitch
—
last modified
Jun 11, 2006 12:22 AM
Improve querying so that multiple catalogs do not need to be consulted.
- Proposed by
- mrenoch
- Proposal type
- Architecture
- State
- being-discussed
Motivation
Right now, many methods have to hit multiple catalogs to find the query results. I am considering adding the needed indexes directly to the ref_catalog, or maybe even building a catalog of my own, but for the moment this is working fine on small sites.
I am open to design suggestions here
Proposal
Either add the indexes I need to the ref_catalog, or to the portal_catalog, or build my own catalog, but doubling up on catalog hits can't be a good thing.