- Patch #291064 by mustafau: improve performance of aggregator by storing an md5 hash for the feed.

1 files changed, 16 insertions, 0 deletions

diff --git a/modules/aggregator/aggregator.install b/modules/aggregator/aggregator.install
index 3b9c181b4..7f672d948 100644
--- a/modules/aggregator/aggregator.install
+++ b/modules/aggregator/aggregator.install
@@ -158,6 +158,13 @@ function aggregator_schema() {
         'size' => 'big',
         'description' => t('An image representing the feed.'),
       ),
+      'hash' => array(
+        'type' => 'varchar',
+        'length' => 32,
+        'not null' => TRUE,
+        'default' => '',
+        'description' => t('Calculated md5 hash of the feed data, used for validating cache.'),
+      ),
       'etag' => array(
         'type' => 'varchar',
         'length' => 255,
@@ -247,3 +254,12 @@ function aggregator_schema() {
 
   return $schema;
 }
+
+/**
+ * Add hash column to aggregator_feed table.
+ */
+function aggregator_update_7000() {
+  $ret = array();
+  db_add_field($ret, 'aggregator_feed', 'hash', array('type' => 'varchar', 'length' => 32, 'not null' => TRUE, 'default' => ''));
+  return $ret;
+}