[development] Requiring node revisions

David Strauss david at fourkitchens.com
Thu Jun 7 20:03:56 UTC 2007

Derek Wright wrote:
> 1) {node_revisions} *ALWAYS* has at least 1 record for any given node. 
> that's where title, body, etc are stored.  please read the schema if you
> have further questions.  therefore, the only site with an empty
> {node_revisions} table is the site with no nodes at all.
> 2) {node_revisions} has an index on nid, and we always JOIN on nid.  by
> and large, the cost of this JOIN is constant, regardless of the # of
> rows in the table, since the JOINs basically always use the index.

Actually, we join on vid, but that also has an index. You're correct
about the rest, though. Extra revisions have little effect on the JOIN

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 186 bytes
Desc: OpenPGP digital signature
Url : http://lists.drupal.org/pipermail/development/attachments/20070607/afb88848/attachment.pgp 

More information about the development mailing list