Page MenuHomePhabricator

add an index over (gil_wiki, gil_page_namespace_id, gil_page_title) to globalimagelinks.
Closed, ResolvedPublic

Description

an index over (gil_wiki, gil_page_namespace_id, gil_page_title) would be very helpful, since it would allow listing all images used on a given page without knowing the page's id. This is esxpecially important if retrieving image usage on several pages on different wikis. Without this index, it would require one query per wiki. If this index is added, it can easily and efficiently be done with a single query.


Version: unspecified
Severity: enhancement

Details

Reference
bz22633

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 11:06 PM
bzimport added a project: GlobalUsage.
bzimport set Reference to bz22633.

nice, thanks! any change to see this index on the wikimedia cluster soon? should I file a separate request?

Gilles raised the priority of this task from Medium to Unbreak Now!.Dec 4 2014, 10:12 AM
Gilles moved this task from Untriaged to Done on the Multimedia board.
Gilles lowered the priority of this task from Unbreak Now! to Medium.Dec 4 2014, 11:22 AM