Tim Starling wrote:
Brion Vibber wrote:
The fields required to do this efficiently aren't there; the revision table has no namespace information.
We can't add the fields either, if we copied the namespace to the revision table, then we'd lose constant time page moves. It seems to be an O(N) problem whichever way you look at it, unless someone else has some bright ideas?
Weeeeellll, we _could_ add indexable summary fields, and update them lazily in the background when required.
Still means a database layout change to the revision table, which might be a little expensive on upgrade.
-- brion vibber (brion @ pobox.com)