From 55d90b2f621a9c144b54b07b4e1dafd0fdad0e85 Mon Sep 17 00:00:00 2001
From: Bostjan Skufca <bostjan@a2o.si>
Date: Sun, 10 Apr 2016 04:50:53 -0400
Subject: [PATCH] mailbox/listing: Make server response for large mailbox listing faster when using threaded view
---
program/steps/utils/killcache.inc | 29 +++++++++++++++++------------
1 files changed, 17 insertions(+), 12 deletions(-)
diff --git a/program/steps/utils/killcache.inc b/program/steps/utils/killcache.inc
index 033cdd0..1adaebd 100644
--- a/program/steps/utils/killcache.inc
+++ b/program/steps/utils/killcache.inc
@@ -26,24 +26,29 @@
}
// @TODO: transaction here (if supported by DB) would be a good thing
-$res = $RCMAIL->db->query("DELETE FROM cache");
-if (PEAR::isError($res)) {
- exit($res->getMessage());
+$res = $RCMAIL->db->query("DELETE FROM " . $RCMAIL->db->table_name('cache', true));
+if ($err = $RCMAIL->db->is_error($res)) {
+ exit($err);
}
-$res = $RCMAIL->db->query("DELETE FROM cache_messages");
-if (PEAR::isError($res)) {
- exit($res->getMessage());
+$res = $RCMAIL->db->query("DELETE FROM " . $RCMAIL->db->table_name('cache_shared', true));
+if ($err = $RCMAIL->db->is_error($res)) {
+ exit($err);
}
-$res = $RCMAIL->db->query("DELETE FROM cache_index");
-if (PEAR::isError($res)) {
- exit($res->getMessage());
+$res = $RCMAIL->db->query("DELETE FROM " . $RCMAIL->db->table_name('cache_messages', true));
+if ($err = $RCMAIL->db->is_error($res)) {
+ exit($err);
}
-$res = $RCMAIL->db->query("DELETE FROM cache_thread");
-if (PEAR::isError($res)) {
- exit($res->getMessage());
+$res = $RCMAIL->db->query("DELETE FROM " . $RCMAIL->db->table_name('cache_index', true));
+if ($err = $RCMAIL->db->is_error($res)) {
+ exit($err);
+}
+
+$res = $RCMAIL->db->query("DELETE FROM " . $RCMAIL->db->table_name('cache_thread', true));
+if ($err = $RCMAIL->db->is_error($res)) {
+ exit($err);
}
echo "Cache cleared\n";
--
Gitblit v1.9.1