#363262 by catch and Damien Tournoud: Replace src index on the {url_alias} table with src, language for better performance.

1 files changed, 12 insertions, 1 deletions

diff --git a/modules/system/system.install b/modules/system/system.install
index 8a253ecaa..9ac9f0264 100644
--- a/modules/system/system.install
+++ b/modules/system/system.install
@@ -1260,7 +1260,7 @@ function system_schema() {
     ),
     'primary key' => array('pid'),
     'indexes' => array(
-      'src' => array('src'),
+      'src_language' => array('src', 'language'),
     ),
   );
 
@@ -3197,6 +3197,17 @@ function system_update_7017() {
 }
 
 /**
+ * Replace src index on the {url_alias} table with src, language.
+ */
+function system_update_7018() {
+  $ret = array();
+  db_add_index($ret, 'url_alias', 'src_language', array('src', 'language'));
+  db_drop_index($ret, 'url_alias', 'src');
+
+  return $ret;
+}
+
+/**
  * @} End of "defgroup updates-6.x-to-7.x"
  * The next series of updates should start at 8000.
  */