Catrope has uploaded a new change for review.
https://gerrit.wikimedia.org/r/294111
Change subject: Add index on notification_event
......................................................................
Add index on notification_event
So we can easily query the notification rows that belong to
a given event row.
Change-Id: I99fc31a62b37259d7000577583c8e8a599e400f9
---
A db_patches/patch-add-notification_event-index.sql
M echo.sql
2 files changed, 2 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/Echo
refs/changes/11/294111/1
diff --git a/db_patches/patch-add-notification_event-index.sql
b/db_patches/patch-add-notification_event-index.sql
new file mode 100644
index 0000000..1243b80
--- /dev/null
+++ b/db_patches/patch-add-notification_event-index.sql
@@ -0,0 +1 @@
+CREATE INDEX /*i*/echo_notification_event ON /*_*/echo_notification
(notification_event);
diff --git a/echo.sql b/echo.sql
index 910203a..392e1d0 100644
--- a/echo.sql
+++ b/echo.sql
@@ -30,6 +30,7 @@
CREATE INDEX /*i*/echo_notification_user_base_timestamp ON
/*_*/echo_notification (notification_user, notification_bundle_base,
notification_timestamp, notification_event);
CREATE INDEX /*i*/echo_notification_user_hash_timestamp ON
/*_*/echo_notification (notification_user, notification_bundle_hash,
notification_timestamp);
CREATE INDEX /*i*/echo_notification_user_hash_base_timestamp ON
/*_*/echo_notification (notification_user, notification_bundle_display_hash,
notification_bundle_base, notification_timestamp);
+CREATE INDEX /*i*/echo_notification_event ON /*_*/echo_notification
(notification_event);
CREATE TABLE /*_*/echo_email_batch (
eeb_id int unsigned not null primary key auto_increment,
--
To view, visit https://gerrit.wikimedia.org/r/294111
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I99fc31a62b37259d7000577583c8e8a599e400f9
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/extensions/Echo
Gerrit-Branch: master
Gerrit-Owner: Catrope <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
