dépôts / lhc / web / wiklou.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: b87966f) | patch
Redo WhatLinksHere query and add a *_from_namespace field to link tables
authorAaron Schulz <aschulz@wikimedia.org>
Thu, 6 Mar 2014 23:01:35 +0000 (15:01 -0800)
committerOri Livneh <ori@wikimedia.org>
Mon, 21 Jul 2014 19:04:56 +0000 (12:04 -0700)
commitb8c038f6784ef08205f7cf6d7cc11462140e3fa2
tree2a0c071c75d1aa8df7f760ca2cbe3d41e6403368tree | snapshot
parentb87966f6bbd753655cd684cbddd0ec7fe8e6616ccommit | diff
Redo WhatLinksHere query and add a *_from_namespace field to link tables

* Also tweaked the query so MySQL avoids doing a page_name
  index scan when it should start with the link table index
* Added population script (triggered by update.php)
* Also removed uniqueness from some indexes where it is redundant
* Renamed two confusing variables

Bug: 60618
Change-Id: Icca99b6ae0ef76cb77695faf82c615516191da36
17 files changed:
RELEASE-NOTES-1.24 diff | blob | history
includes/AutoLoader.php diff | blob | history
includes/DefaultSettings.php diff | blob | history
includes/Title.php diff | blob | history
includes/deferred/LinksUpdate.php diff | blob | history
includes/installer/DatabaseUpdater.php diff | blob | history
includes/installer/MysqlUpdater.php diff | blob | history
includes/installer/PostgresUpdater.php diff | blob | history
includes/installer/SqliteUpdater.php diff | blob | history
includes/specials/SpecialMergeHistory.php diff | blob | history
includes/specials/SpecialWhatlinkshere.php diff | blob | history
maintenance/archives/patch-il_from_namespace.sql [new file with mode: 0644] blob
maintenance/archives/patch-pl_from_namespace.sql [new file with mode: 0644] blob
maintenance/archives/patch-tl_from_namespace.sql [new file with mode: 0644] blob
maintenance/populateBacklinkNamespace.php [new file with mode: 0644] blob
maintenance/postgres/tables.sql diff | blob | history
maintenance/tables.sql diff | blob | history
Wiklou, le Wiki du Wiklou