Get entity revision IDs in bulk
Closed, ResolvedPublic
Actions

Description

CachingResultsBuilder::getLatestRevisionIds gets the latest revision ID per entity one by one. It would be more efficient to do this in bulk, perhaps using WikiPageEntityMetaDataAccessor.

Details

	Subject	Repo	Branch	Lines +/-
	Get revision IDs in bulk	mediawiki/extensions/WikibaseQualityConstraints	master	+67 -53

Customize query in gerrit

Related Objects
Search...

Status	Assigned	Task
Resolved	Lucas_Werkmeister_WMDE	T173695 Enable constraint checks by default for users
Open	None	T103228 Improve performance of constraint check
Resolved	Lydia_Pintscher	T179839 Cache constraint check results
Resolved	Lydia_Pintscher	T179849 Cache all constraint check results per-entity
Resolved	Lucas_Werkmeister_WMDE	T181060 Cache constraint check results per-entity in ObjectCache (L) (days: 2)
Resolved	Lucas_Werkmeister_WMDE	T182994 Get entity revision IDs in bulk

Event Timeline

Lucas_Werkmeister_WMDE triaged this task as Medium priority.Dec 15 2017, 3:35 PM

Lucas_Werkmeister_WMDE created this task.

Lucas_Werkmeister_WMDE lowered the priority of this task from Medium to Low.Dec 15 2017, 3:38 PM

Lucas_Werkmeister_WMDE added a project: Wikidata-Sprint-2018-01-03.Jan 3 2018, 4:34 PM

Change 401752 had a related patch set uploaded (by Lucas Werkmeister (WMDE); owner: Lucas Werkmeister (WMDE)):
[mediawiki/extensions/WikibaseQualityConstraints@master] Get revision IDs in bulk

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

gerritbot added a project: Patch-For-Review.Jan 3 2018, 4:48 PM

Lucas_Werkmeister_WMDE moved this task from Backlog to Review on the Wikidata-Sprint-2018-01-03 board.Jan 3 2018, 4:50 PM

Change 401752 merged by jenkins-bot:
[mediawiki/extensions/WikibaseQualityConstraints@master] Get revision IDs in bulk

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

Lucas_Werkmeister_WMDE moved this task from Review to Done on the Wikidata-Sprint-2018-01-03 board.Jan 4 2018, 12:22 PM

ReleaseTaggerBot added a project: MW-1.31-release-notes (WMF-deploy-2018-01-09 (1.31.0-wmf.16)).Jan 4 2018, 1:01 PM

Lucas_Werkmeister_WMDE closed this task as Resolved.Jan 9 2018, 12:09 PM

Lucas_Werkmeister_WMDE claimed this task.

Lucas_Werkmeister_WMDE mentioned this in T188381: Avoid joining three tables just to get the latest revision ID.Feb 27 2018, 10:18 AM