Hi,
it appears that [[Special:Contributions/Timwi]] loads relatively quickly. However, if you choose a namespace in which I have very little contributions (e.g. Image talk, Category talk), it takes ages to appear. This leads me to believe that a relevant index is missing on the DB table?
Timwi
Timwi wrote:
it appears that [[Special:Contributions/Timwi]] loads relatively quickly. However, if you choose a namespace in which I have very little contributions (e.g. Image talk, Category talk), it takes ages to appear.
Aye, that's why this feature was removed.
If somebody put it back, they should be shot.
This leads me to believe that a relevant index is missing on the DB table?
The fields required to do this efficiently aren't there; the revision table has no namespace information.
-- brion vibber (brion @ pobox.com)
On 21/05/06, Brion Vibber brion@pobox.com wrote:
Timwi wrote:
it appears that [[Special:Contributions/Timwi]] loads relatively quickly. However, if you choose a namespace in which I have very little contributions (e.g. Image talk, Category talk), it takes ages to appear.
Aye, that's why this feature was removed.
If somebody put it back, they should be shot.
The log for SpecialContributions.php makes interesting reading.
Rob Church
Brion Vibber wrote:
Timwi wrote:
This leads me to believe that a relevant index is missing on the DB table?
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?
-- Tim Starling
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)
Hi!
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.
It can be a task for tool server, and can be as well derived from our xml dumps.
We have all that information in recentchanges (without an index for this exact operation), but even then, I'm not convinced it has to be used his way.
What is the point of per-namespace contribution feature on live site? What are the applications of it?
Domas
On 23/05/06, Domas Mituzas midom.lists@gmail.com wrote:
What is the point of per-namespace contribution feature on live site? What are the applications of it?
I've forwarded this question to the user base at large.
Rob Church
wikitech-l@lists.wikimedia.org