-----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)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (Darwin)
Comment: Using GnuPG with Mozilla -
http://enigmail.mozdev.org
iEYEARECAAYFAkgFH2oACgkQwRnhpk1wk45SlgCgm9aKhlpRanfkr1MZ4BuGyCBr
l/wAoJjtA1ueZRs1KRvLUa56mfcS1b7b
=eSHr
-----END PGP SIGNATURE-----