MarkAHershberger has uploaded a new change for review. https://gerrit.wikimedia.org/r/133272
Change subject: Introducing pp_sortkey. ...................................................................... Introducing pp_sortkey. This adds the pp_sortkey column to the page_props table. pp_sortkeys allows for top-k queries for pages, e.g. the 100 pages with the most language links, etc. It is also possible to query for exact values. For now, pp_sortkey will contain pp_value's numeric value if the value was set to a float, int or boolean. Associated tasks: * create a maintenance script for populating pp_sortkey. Tricky, because when reading from the database, all values are strings. * create an API module for querying pages by property value. bug: 58032 hand picked from Change-Id: I217c42656fb877ff35a36eb446a22bdaf119faac Change-Id: I89b6fc719f70a225a0a71290cc6e051f464114b7 --- M RELEASE-NOTES-1.23 1 file changed, 6 insertions(+), 0 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/mediawiki/core refs/changes/72/133272/1 diff --git a/RELEASE-NOTES-1.23 b/RELEASE-NOTES-1.23 index bbf2d0a..c2a9c49 100644 --- a/RELEASE-NOTES-1.23 +++ b/RELEASE-NOTES-1.23 @@ -9,6 +9,9 @@ production. === Configuration changes in 1.23 === +* Introduced $wgPagePropsHaveSortkey as a backwards-compatibility switch, + for using the old schema of the page_props table, in case the respective + schema update was not applied. * (bug 13250) Restored method for clearing a watchlist in web UI so that users with large watchlists don't have to perform contortions to clear them. @@ -272,6 +275,9 @@ * Support was added for Northern Luri (lrc). === Other changes in 1.23 === +* Added pp_sortkey column to page_props table, so pages can be efficiently + queried and sorted by property value (bug 58032). + See $wgPagePropsHaveSortkey if you want to postpone the schema change. * The rc_type field in the recentchanges table has been superseded by a new rc_source field. The rc_source field is a string representation of the change type where rc_type was a numeric constant. This field is not yet -- To view, visit https://gerrit.wikimedia.org/r/133272 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I89b6fc719f70a225a0a71290cc6e051f464114b7 Gerrit-PatchSet: 1 Gerrit-Project: mediawiki/core Gerrit-Branch: REL1_23 Gerrit-Owner: MarkAHershberger <m...@nichework.com> Gerrit-Reviewer: Daniel Kinzler <daniel.kinz...@wikimedia.de> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
