Add method(s) to preload the edit count for multiple users
Closed, ResolvedPublic2 Estimated Story Points
Actions

Description

During the code review of https://gerrit.wikimedia.org/r/c/mediawiki/core/+/1224698, it was raised that retrieving the edit count for each user in a page with lots of them (such as a contributions list) is not efficient.
We should be able to prefill an in-memory cache with the edit count for each user in a given listing, so that we don't issue a separate query for each

Acceptance criteria

A method in either the UserLinkRenderer or the UserEditTracker exists to populate a cache of edit counts

Details

Related Changes in Gerrit:

	Subject	Repo	Branch	Lines +/-
	UserEditTracker: Add a method to preload the edit count cache explicitly	mediawiki/core	master	+132 -2

Customize query in gerrit

Related Objects
Search...

		Status	Subtype	Assigned	Task
		In Progress	BUG REPORT	hector.arroyo	T412013 "contribs" is redundant for temporary accounts
		Resolved		hector.arroyo	T414950 Add method(s) to preload the edit count for multiple users

Event Timeline

hector.arroyo created this task.Mon, Jan 19, 12:13 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMon, Jan 19, 12:13 PM

hector.arroyo changed the task status from Open to In Progress.Mon, Jan 19, 12:14 PM

hector.arroyo added a parent task: T412013: "contribs" is redundant for temporary accounts.

hector.arroyo updated the task description. (Show Details)

hector.arroyo set the point value for this task to 2.

hector.arroyo added projects: Temporary accounts, OKR-Work.Mon, Jan 19, 12:16 PM

Change #1228532 had a related patch set uploaded (by Harroyo-wmf; author: Harroyo-wmf):

[mediawiki/core@master] UserEditTracker: Add a method to preload the edit count cache explicitly

https://gerrit.wikimedia.org/r/1228532

gerritbot added a project: Patch-For-Review.Mon, Jan 19, 3:31 PM

hector.arroyo updated the task description. (Show Details)Mon, Jan 19, 4:57 PM

hector.arroyo updated the task description. (Show Details)Mon, Jan 19, 5:00 PM

OKryva-WMF edited projects, added Product Safety and Integrity (Sprint Daffodil (Jan 19 - Feb 6)); removed Product Safety and Integrity (Essential Work Sprint (Dec 15th - Jan 9th)).Tue, Jan 20, 12:50 PM

OKryva-WMF edited projects, added Essential-Work; removed OKR-Work.Tue, Jan 20, 1:04 PM

OKryva-WMF moved this task from Backlog to In progress on the Product Safety and Integrity (Sprint Daffodil (Jan 19 - Feb 6)) board.

hector.arroyo moved this task from In progress to Needs review on the Product Safety and Integrity (Sprint Daffodil (Jan 19 - Feb 6)) board.Tue, Jan 20, 1:16 PM

hector.arroyo mentioned this in T415198: Preload the edit count cache in Special:RecentChanges.Wed, Jan 21, 2:33 PM

Changes to preload the edit count in the ContributionsPager have been rolled back: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/1228532/20..24

OKryva-WMF moved this task from Inbox to Next on the Temporary accounts board.Wed, Jan 28, 1:09 PM

Also needed for CheckUser-SuggestedInvestigations, so tagging that task with that

The change associated with this task is being merged now. Given this is a new internal functionality not changing any user-facing behavior, I think this can skip QA.

Change #1228532 merged by jenkins-bot:

[mediawiki/core@master] UserEditTracker: Add a method to preload the edit count cache explicitly

https://gerrit.wikimedia.org/r/1228532

Maintenance_bot removed a project: Patch-For-Review.Wed, Jan 28, 2:32 PM

ReleaseTaggerBot added a project: MW-1.46-notes (1.46.0-wmf.14; 2026-02-03).Wed, Jan 28, 3:00 PM

hector.arroyo moved this task from Backlog to Done on the CheckUser-SuggestedInvestigations board.Mon, Feb 2, 5:25 PM