shivaganeshp1619
is there anything to change in the code level to make it fast?
You can only apply a patch to calculate Queue Counts individually instead of one big query:
diff --git a/include/class.search.php b/include/class.search.php
index f0b770f0..9d0cd0f3 100755
--- a/include/class.search.php
+++ b/include/class.search.php
@@ -992,12 +992,12 @@ class SavedQueue extends CustomQueue {
$counts['q'.$queue->getId()] = '-';
}
- try {
- $counts = array_merge($counts, $query->values()->one());
- } catch (Exception $ex) {
+ //try {
+ // $counts = array_merge($counts, $query->values()->one());
+ //} catch (Exception $ex) {
foreach ($queues as $q)
$counts['q'.$q->getId()] = $q->getTotal();
- }
+ //}
// Always cache the results
self::storeCounts($key, $counts, $ttl);
You sure kevin that upgrading to the latest version will solve this problem?
It may not, but you need to be on a supported version anyways to receive any kind of support.
But I also have a massive 40GB of attachments in production DB
Yes, it can have an affect. You can install Filesystem plugin and migrate attachments from db to server.
Cheers.
