As noted in https://gerrit.wikimedia.org/r/#/c/209123/2/includes/api/ApiQueryListPages.php, without this sorting a single list by title will require a filesort (which would be OK for small lists but there is no size limit currently and there are use cases for huge lists).
Description
Description
Details
Details
| Subject | Repo | Branch | Lines +/- | |
|---|---|---|---|---|
| Add (gli_gl_id, gli_namespace, gli_title) index | mediawiki/extensions/Gather | master | +12 -0 |
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Invalid | Tgr | T95786 Collection items should be sorted by modified time not alphabetically. | |||
| Duplicate | None | T94255 UI for reordering collections | |||
| Duplicate | None | T94117 API: support page reordering | |||
| Resolved | Tgr | T95972 API: Change default ordering of page titles namespace | |||
| Invalid | None | T51188 [DO NOT USE] Schema changes for Wikimedia wikis (tracking) [superseded by #Blocked-on-schema-change] | |||
| Resolved | Tgr | T98490 Add (list, title) index for Gather lists |
Event Timeline
Comment Actions
Change 209502 had a related patch set uploaded (by Gergő Tisza):
Add (gli_gl_id, gli_namespace, gli_title) index
Comment Actions
To deploy on WMF servers, run for db in testwiki test2wiki enwiki; do mwscript sql.php --wiki=$db /srv/mediawiki/php/extensions/Gather/schema/archive/add-gli_id_ns_title.sql; done on terbium.
Comment Actions
Not sure if the last column of the (gli_namespace, gli_title, gli_gl_id) index is still needed after this change, it seems to only be there to enforce uniqueness.