On Fri, Mar 20, 2009 at 1:08 PM, O. O. olson_ot@yahoo.com wrote:
I cannot understand why there are more redirects in the redirect table than there are in the pages in the Page table with the redirect flag set.
select count(*) from wikidb.redirect ; --- Gives 3422938
while
select count(*) from wikidb.page where page_is_redirect=1; --- Gives 3242340
Why should there be this difference? Are there redirects that are not listed in the Page Table?
It's denormalized data, so I'd assume that those are just errors of some kind. If you need to be really really sure whether something is a redirect, you have to parse its text (it's just a regex, should be somewhere in includes/Article.php or something). That's the authoritative check, which IIRC is used when actually deciding whether to redirect.