Changeset 28560 for trunk/include/functions_notification.inc.php

Timestamp:

May 29, 2014, 7:27:57 AM (10 years ago)

Author:

rvelices

Message:

added persistent cache for some slow queries in feed notification (even if not important to be fast on RSS feed, it might slow down galleries that are very large and actively used)

File:

• trunk/include/functions_notification.inc.php (modified) (2 diffs)

trunk/include/functions_notification.inc.php

@@ -442 +442 @@
 function get_recent_post_dates($max_dates, $max_elements, $max_cats)
 {
-  global $conf, $user;
-
+  global $conf, $user, $persistent_cache;
+
+  $cache_key = $persistent_cache->make_key('recent_posts'.$user['id'].$user['cache_update_time'].$max_dates.$max_elements.$max_cats);
+  if ($persistent_cache->get($cache_key, $cached))
+  {
+    return $cached;
+  }
   $where_sql = get_std_sql_where_restrict_filter('WHERE', 'i.id', true);
 
@@ -494 +499 @@
   }
 
+  $persistent_cache->set($cache_key, $dates);
   return $dates;
 }