Changeset 28432

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

Location:

trunk

Files:

• admin/maintenance.php (modified) (1 diff)
• admin/plugins_installed.php (modified) (1 diff)
• include/cache.class.php (added)
• include/common.inc.php (modified) (1 diff)
• include/functions.inc.php (modified) (1 diff)
• include/section_init.inc.php (modified) (3 diffs)

trunk/admin/maintenance.php

@@ -147 +147 @@
     $template->delete_compiled_templates();
     FileCombiner::clear_combined_files();
+    $persistent_cache->purge(true);
     break;
   }

trunk/admin/plugins_installed.php

@@ -78 +78 @@
       {
         $template->delete_compiled_templates();
+        $persistent_cache->purge(true);
       }
       redirect($base_url);

trunk/include/common.inc.php

@@ -104 +104 @@
 include(PHPWG_ROOT_PATH . 'include/functions.inc.php');
 
+$persistent_cache = new PersistentFileCache();
 
 // Database connection

trunk/include/functions.inc.php

@@ -38 +38 @@
 include_once( PHPWG_ROOT_PATH .'include/derivative.inc.php');
 include_once( PHPWG_ROOT_PATH .'include/template.class.php');
+include_once( PHPWG_ROOT_PATH .'include/cache.class.php');
 
 

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']);
+    }
   }
 }