Changeset 28432 for trunk/include/section_init.inc.php

Timestamp:

May 11, 2014, 10:26:41 AM (10 years ago)

Author:

rvelices

Message:

added a persistent cache mechanism; used so far to cache image ids in flat view mode

File:

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

trunk/include/section_init.inc.php

@@ -292 +292 @@
       else
       {
+        $cache_key = $persistent_cache->make_key('all_iids'.$user['id'].$user['cache_update_time'].$conf['order_by']);
         unset($page['is_homepage']);
         $where_sql = '1=1';
@@ -302 +303 @@
     }
 
-    // main query
-    $query = '
+    if ( !isset($cache_key) || !$persistent_cache->get($cache_key, $page['items']))
+    {
+      // main query
+      $query = '
 SELECT DISTINCT(image_id)
   FROM '.IMAGE_CATEGORY_TABLE.'
@@ -313 +316 @@
 ;';
 
-    $page['items'] = query2array($query,null, 'image_id');
+      $page['items'] = query2array($query,null, 'image_id');
+      
+      if ( isset($cache_key) )
+        $persistent_cache->set($cache_key, $page['items']);
+    }
   }
 }