Delay on Database

konfidoosticket

I have a problem when logging into osticket as an administrator, since it takes a long time to access my tickets, when I access another part of the application I don't have any problem, but when I want to see the tickets section, I wait a long time and I don't loads them.

KevinTheJedi

konfidoosticket

You truly need to optimize MySQL. However, in the meantime you can apply this below patch to speed up the counts until you optimize your MySQL instance:

diff --git a/include/class.search.php b/include/class.search.php
index 5851a8ac..fb0d0184 100755
--- a/include/class.search.php
+++ b/include/class.search.php
@@ -1005,12 +1005,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);

Cheers.