- Patch #257910 by douggreen et al: Performance Issue during Indexing - search_dataset.sid_type unique key should be an Index.

2 files changed, 11 insertions, 1 deletions

diff --git a/modules/search/search.install b/modules/search/search.install
index b6e3b7c12..684e85e4d 100644
--- a/modules/search/search.install
+++ b/modules/search/search.install
@@ -55,7 +55,7 @@ function search_schema() {
         'description' => t('Set to force node reindexing.'),
       ),
     ),
-    'unique keys' => array(
+    'indexes' => array(
       'sid_type' => array('sid', 'type'),
     ),
   );
diff --git a/modules/system/system.install b/modules/system/system.install
index f84bc570c..3a7bec61c 100644
--- a/modules/system/system.install
+++ b/modules/system/system.install
@@ -3101,6 +3101,16 @@ function system_update_7011() {
 }
 
 /**
+ * Replace unique key 'sid_type' by indexes in 'search_dataset' table.
+ */
+function system_update_7012() {
+  $ret = array();
+  db_drop_unique_key($ret, 'search_dataset', 'sid_type');
+  db_add_index($ret, 'search_dataset', 'sid_type', array('sid', 'type'));
+  return $ret;
+}
+
+/**
  * @} End of "defgroup updates-6.x-to-7.x"
  * The next series of updates should start at 8000.
  */