Author: jutiphan
Description:
The latest version has the feature to get user contributions for new accounts. Example: http://en.wikipedia.org/w/index.php?limit=50&title=Special%3AContributions&contribs=newbie&target=Jutiphan&namespace=&year=&month=-1
I would like to have such feature in the API. Please implement it. Thanks.
Version: unspecified
Severity: enhancement
URL: http://en.wikipedia.org/w/api.php
(In reply to comment #0)
The latest version has the feature to get user contributions for new accounts.
Actually, this feature seems to have been around forever, or at least for longer than ViewVC's history search thingy will let me go (Dec 2006).
The weird thing here is that running an EXPLAIN on the query it uses tells me it filesorts, and it seems impossible to write a non-filesorting query that doesn't sort by user ID first (which is kind of useless).
Resolving as WONTFIX as I don't see how it can be done efficiently; the Special:Contributions implementation could perhaps use a critical look from Domas.
ayg wrote:
The query should just use rev_timestamp. It would have to discard most of the rows, but it would probably be a lot faster than the filesort. The current query seems to be taking a half-second on enwiki, according to forceprofile=true. Since views don't support FORCE INDEX, though, I can't test the alternative version on a real database.