Changeset 2890

Timestamp:

11/19/08 21:03:49 (5 years ago)

Author:

rub

Message:

Delete caches and optimize tables on upgrade

Location:

trunk

Files:

• admin/include/functions.php (modified) (1 diff)
• admin/maintenance.php (modified) (1 diff)
• upgrade.php (modified) (2 diffs)

trunk/admin/include/functions.php

@@ -1763 +1763 @@
  * Invalidates cahed data (permissions and category counts) for all users.
  */
-function invalidate_user_cache()
-{
-  $query = '
+function invalidate_user_cache($full = true)
+{
+  if ($full)
+  {
+    $query = '
+TRUNCATE TABLE '.USER_CACHE_CATEGORIES_TABLE.';';
+    pwg_query($query);
+    $query = '
+TRUNCATE TABLE '.USER_CACHE_TABLE.';';
+    pwg_query($query);
+  }
+  else
+  {
+    $query = '
 UPDATE '.USER_CACHE_TABLE.'
-  SET need_update = \'true\'';
-  pwg_query($query);
+  SET need_update = \'true\';';
+    pwg_query($query);
+  }
   trigger_action('invalidate_user_cache');
 }

trunk/admin/maintenance.php

@@ -47 +47 @@
     update_category('all');
     update_global_rank();
-    invalidate_user_cache();
+    invalidate_user_cache(true);
     break;
   }

trunk/upgrade.php

@@ -299 +299 @@
       );
 
-    invalidate_user_cache();
-
     // c13y_upgrade plugin means "check integrity after upgrade", so it
     // becomes useful just after an upgrade
@@ -309 +307 @@
 ;';
     pwg_query($query);
+
+    // Delete cache data
+    invalidate_user_cache(true);
+    $template->delete_compiled_templates();
+
+    // Tables Maintenance
+    do_maintenance_all_tables();
+
   }
 }