when opening tickets page as an agent, it is taking 10-15 secs to load the page.
I have tried all the solutions from the discussions like disabling the verify email domain etc
osticket is running on centOs vm with 16gb ram and 1TB storage.
osTicket Version v1.14.3 (f4f5bc6) — v1.14.8 is available
Web Server Software nginx/1.18.0
MySQL Version 8.0.22
PHP Version 7.4.33
Cheers.
is there anything to change in the code level to make it fast?
and also how to update the osticket version without loosing the data.
thanks in advance
You sure kevin that upgrading to the latest version will solve this problem?
Already all tables are using InnoDb engine, and dymanic row formatting as well
But I also have a massive 40GB of attachments in production DB
can it be the issue for slowing down the tickets page??
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.
so if I install the FileSystem plugin, is it mandatory to migrate my data from DB to file system?
even after I install FileSystem plugin and keep using it, can I access the files which are stored in DB? (If not migrated)
No and yes. You would want to migrate the file data to the filesystem to free space in MySQL which should improve performance.
Cheers.