Brion Vibber schreef:
Bugs 13752 and 13754 should be fixable
without reverting to the old (and inefficient) behavior (possibly with a
schema change to the redirect table, as I suggested in response to r33375).
...which would require adding interwiki and fragment field and god knows
what else,
I don't really see what else: what other types of redirect do we
have,
besides section, interwiki and vanilla redirects?
and wouldn't actually make much of anything
relevant more
efficient, since individual lookups are fairly cheap.
I thought WMF wikis stored
their text tables on separate servers? In
that case, using the revision text would not only replace the SELECT on
the redirect table by one on the page and revision tables (a join on two
tables that are each larger than the redirect table, so it's very likely
slower), but also cause more inter-server communications (probably even
slower than a DB query). I know we're talking about milliseconds (or
fractions of them?) here, but surely even those matter on large wikis
(like WMF)?
Roan Kattouw (Catrope)