Changeset 28491 for trunk/include/functions_calendar.inc.php

Timestamp:

May 17, 2014, 8:09:33 AM (10 years ago)

Author:

rvelices

Message:

use persistent cache for calendar list in root flat mode (same perf improvement as category flat view)

File:

• trunk/include/functions_calendar.inc.php (modified) (3 diffs)

trunk/include/functions_calendar.inc.php

@@ -37 +37 @@
 function initialize_calendar()
 {
-  global $page, $conf, $user, $template, $filter;
+  global $page, $conf, $user, $template, $persistent_cache, $filter;
 
 //------------------ initialize the condition on items to take into account ---
@@ -270 +270 @@
   if ($must_show_list)
   {
-    $query = 'SELECT DISTINCT id ';
-    $query .= ','.$calendar->date_field;
-    $query .= $calendar->inner_sql.'
-  '.$calendar->get_date_where();
     if ( isset($page['super_order_by']) )
     {
-      $query .= '
-  '.$conf['order_by'];
+      $order_by = $conf['order_by'];
     }
     else
@@ -294 +289 @@
         'ORDER BY '.$calendar->date_field.$order, $conf['order_by']
         );
-      $query .= '
+    }
+    
+    if ('categories'==$page['section'] && !isset($page['category'])
+      && ( count($page['chronology_date'])==0
+            OR ($page['chronology_date'][0]=='any' && count($page['chronology_date'])==1) )
+      )
+    {
+      $cache_key = $persistent_cache->make_key($user['id'].$user['cache_update_time']
+        .$calendar->date_field.$order_by);
+    }
+
+    if ( !isset($cache_key) || !$persistent_cache->get($cache_key, $page['items']))
+    {
+      $query = 'SELECT DISTINCT id '
+        .$calendar->inner_sql.'
+  '.$calendar->get_date_where().'
   '.$order_by;
-    }
-    $page['items'] = array_from_query($query, 'id');
+      $page['items'] = array_from_query($query, 'id');
+      if ( isset($cache_key) )
+        $persistent_cache->set($cache_key, $page['items']);
+    }
   }
   pwg_debug('end initialize_calendar');