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)