7 Jun
2007
7 Jun
'07
10:03 p.m.
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 performance.