-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Roan Kattouw wrote:
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?
That's _probably_ it. :)
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)?
This lookup'll be dwarfed by the rest of the process of setting up MediaWiki, fetching the target page, possibly rendering it, and outputting a full page of HTML.
It's nice to shave off a little, but it's not the most critical code path.
- -- brion vibber (brion @ wikimedia.org)