From 94392ab00ceefec6105ac7d6e6846fb644bbd0f1 Mon Sep 17 00:00:00 2001 From: Mikael Nordfeldth Date: Thu, 7 Jan 2016 11:39:46 +0100 Subject: [PATCH] Index the verb column since we do COUNT(*) based on it --- classes/Notice.php | 1 + 1 file changed, 1 insertion(+) diff --git a/classes/Notice.php b/classes/Notice.php index 208e4be9a7..f85e9ea233 100644 --- a/classes/Notice.php +++ b/classes/Notice.php @@ -110,6 +110,7 @@ class Notice extends Managed_DataObject 'notice_profile_id_idx' => array('profile_id', 'created', 'id'), 'notice_repeat_of_created_id_idx' => array('repeat_of', 'created', 'id'), 'notice_conversation_created_id_idx' => array('conversation', 'created', 'id'), + 'notice_verb_idx' => array('verb'), 'notice_replyto_idx' => array('reply_to') ) ); -- 2.39.5