Page MenuHomePhabricator
Create Task
Maniphest T344782

New special page to list users by highest edit count
Open, Needs TriagePublicFeature
Actions

Description

Feature summary (what you would like to be able to do and where):

  • New special page (Special:HighestEditCounts?) to list top 100 users with highest edit count

Use case(s) (list the steps that you performed to discover that problem, and describe the actual underlying problem which you want to solve. Do not describe only a solution):

  • Went to go see who has the highest edit counts on metawiki. Couldn't find a page with this info.

Benefits (why should this be implemented?):

  • Useful info. Shouldn't need a third party tool for this. SQL query would be cheap since this information is stored in a field in the user table.

Acceptance criteria

  • create new special page
    • should display username and edit count, descending by edit count
    • maybe also include a column with date of last edit, so you can see if they're active
    • usernames should be hyperlinked to their profile pages
  • make sure it shows up correctly at Special:SpecialPages (probably in the "Users and rights" section)

Related Objects

Event Timeline

Novem_Linguae created this task.Aug 23 2023, 3:23 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptAug 23 2023, 3:23 AM
• taavi added a project: MediaWiki-User-management.Aug 25 2023, 6:46 AM
• taavi subscribed.

SQL query would be cheap since this information is stored in a field in the user table.

That column is not indexed, and filesorts are not cheap.

Bugreporter mentioned this in T352823: Split user table to multiple tables.Dec 6 2023, 12:04 AM
Novem_Linguae added a comment.Dec 12 2023, 6:31 PM

Thanks for the correction taavi. You're completely right. My test query timed out on Quarry. Geez that's slow.

SELECT user_name, user_editcount
FROM user
ORDER BY user_editcount DESC
LIMIT 100

Adding WHERE user_editcount > 100000 gets it down to 60 seconds.

I guess the way to go if someone were to code this would be to do a daily job queue/deferred update, and cache the results?

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits