[drupal-devel] CCK Node Caching Strategies
dries at buytaert.net
Sun Mar 6 07:54:07 UTC 2005
Jonathan Chaffer wrote:
> A simpler implementation is to load each field through a separate query.
> This is a very flexible approach, and allows simple compartmentalization
> of the query code into the field modules. The obvious downside is that
> you need many queries for a simple node load.
> 1x query to fetch node IDs for the ten nodes (10 results)
> 100x queries to fetch each normal field (1 result each)
> 10x queries to fetch the multi-value fields (10 results each)
111 queries is not acceptable. Using a node cache is essential. Where
to store the cached nodes? Well, I'd expect the answer to depend on how
we are going to deal with node revisions. Plus, no decision is set in
stone. We can move the cached copies around if necessary.
Dries Buytaert :: http://www.buytaert.net/
More information about the drupal-devel