Awight has uploaded a new change for review.
https://gerrit.wikimedia.org/r/178572
Change subject: add some indexes to civicrm_prevnext_cache table
......................................................................
add some indexes to civicrm_prevnext_cache table
Change-Id: I7ba41b12154f15376b069482ad567fb2fcd2ced4
---
M sites/all/modules/wmf_civicrm/wmf_civicrm.install
1 file changed, 15 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm
refs/changes/72/178572/1
diff --git a/sites/all/modules/wmf_civicrm/wmf_civicrm.install
b/sites/all/modules/wmf_civicrm/wmf_civicrm.install
index e12a0ec..e0fe651 100644
--- a/sites/all/modules/wmf_civicrm/wmf_civicrm.install
+++ b/sites/all/modules/wmf_civicrm/wmf_civicrm.install
@@ -26,6 +26,7 @@
wmf_civicrm_update_7019();
wmf_civicrm_update_7023();
wmf_civicrm_update_7024();
+ wmf_civicrm_update_7025();
}
/**
@@ -1100,3 +1101,17 @@
}
return $ret;
}
+
+/**
+ * Add indexes to the civicrm_prevnext_cache table
+ */
+function wmf_civicrm_update_7025()
+{
+ $dbs = wmf_civicrm_get_dbs();
+ $dbs->push('civicrm');
+
+ db_query("alter table civicrm_prevnext_cache
+ add index entity_id1 (entity_id1),
+ add index entity_id2 (entity_id2),
+ add index cacheKey (cacheKey)");
+}
--
To view, visit https://gerrit.wikimedia.org/r/178572
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I7ba41b12154f15376b069482ad567fb2fcd2ced4
Gerrit-PatchSet: 1
Gerrit-Project: wikimedia/fundraising/crm
Gerrit-Branch: master
Gerrit-Owner: Awight <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
