From 00e500bbb1b487de635debd5aabd55d5f400b3d8 Mon Sep 17 00:00:00 2001
From: David Rothstein <drothstein@gmail.com>
Date: Mon, 5 May 2014 19:14:59 -0400
Subject: Issue #1790298 by nagba, pwolanin: Unindexed query in aggregator
 module.

---
 modules/aggregator/aggregator.install | 10 ++++++++++
 1 file changed, 10 insertions(+)

(limited to 'modules/aggregator/aggregator.install')

diff --git a/modules/aggregator/aggregator.install b/modules/aggregator/aggregator.install
index b84556a9d..d6cc0392b 100644
--- a/modules/aggregator/aggregator.install
+++ b/modules/aggregator/aggregator.install
@@ -260,6 +260,7 @@ function aggregator_schema() {
     'primary key' => array('iid'),
     'indexes' => array(
       'fid' => array('fid'),
+      'timestamp' => array('timestamp'),
     ),
     'foreign keys' => array(
       'aggregator_feed' => array(
@@ -325,6 +326,15 @@ function aggregator_update_7003() {
   db_add_index('aggregator_feed', 'url', array(array('url', 255)));
 }
 
+/**
+ * Add index on timestamp.
+ */
+function aggregator_update_7004() {
+  if (!db_index_exists('aggregator_item', 'timestamp')) {
+    db_add_index('aggregator_item', 'timestamp', array('timestamp'));
+  }
+}
+
 /**
  * @} End of "addtogroup updates-7.x-extra"
  */
-- 
cgit v1.2.3