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
Related Changes in Gerrit:
| 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.