From 4e2be07234bc0c8fcda47b7a18f9b3b43a7372f3 Mon Sep 17 00:00:00 2001 From: Mikael Nordfeldth Date: Tue, 29 Mar 2016 12:13:33 +0200 Subject: [PATCH] Better indexing for Notice (performance++) --- classes/Notice.php | 2 ++ 1 file changed, 2 insertions(+) diff --git a/classes/Notice.php b/classes/Notice.php index 256eb61663..6a747e5f5f 100644 --- a/classes/Notice.php +++ b/classes/Notice.php @@ -111,6 +111,8 @@ class Notice extends Managed_DataObject '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_profile_id_verb_idx' => array('profile_id', 'verb'), + 'notice_url_idx' => array('url'), // Qvitter wants this 'notice_replyto_idx' => array('reply_to') ) ); -- 2.39.5