On 13/09/2007, Yousef Ourabi Yousef.Ourabi@cnet.com wrote:
I've looked at the diagram on the mediawiki site -- and it still not clear to me what the page_latest column references (they don't seem to be page_ids)...
It's the revision identifier (rev_id) of the current revision of that page; storing it here is far faster than an inefficient JOIN against revision coupled with a MAX() statement.
Rob Church