- Patch #42463: performance improvement: add index on the source field of the locale table.

1 files changed, 17 insertions, 0 deletions

diff --git a/modules/system/system.install b/modules/system/system.install
index b7fd920dd..ac8aebaa0 100644
--- a/modules/system/system.install
+++ b/modules/system/system.install
@@ -3091,6 +3091,23 @@ function system_update_1007() {
 }
 
 /**
+ * Performance update for queries that are related to the locale.module
+ */
+function system_update_1008() {
+  $ret = array();
+  switch ($GLOBALS['db_type']) {
+    case 'mysql':
+    case 'mysqli':
+      $ret[] = update_sql('ALTER TABLE {locales_source} ADD KEY source (source(30))');
+      break;
+    case 'pgsql':
+      $ret[] = update_sql("CREATE INDEX {locales_source}_source_idx on {locales_source} (source)");
+  }
+
+  return $ret;
+}
+
+/**
  * @} End of "defgroup updates-4.7-to-x.x"
  * The next series of updates should start at 2000.
  */