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

    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??

      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.

      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)

        shivaganeshp1619

        No and yes. You would want to migrate the file data to the filesystem to free space in MySQL which should improve performance.

        Cheers.

        Write a Reply...