Hi,
we run osticket v 1.14.5 and every click is blazing fast. We started the upgrade to 1.17-rc4 because we need oauth for MS emails to work. It was a tough one, but it's working under ubuntu 20 with php 8.0 and mariadb 10.6.
It's now very slow though. Every click takes several seconds. Just the login page takes 11 seconds. Mariadb process is maxing 1 cpu core and the slow-query-log reports 1 slow query.
Time: 220928 19:45:02
User@Host: osticket_user[osticket_user] @ localhost []
Thread_id: 139 Schema: osticket_db QC_hit: No
Query_time: 11.652925 Lock_time: 0.000358 Rows_sent: 25 Rows_examined: 7131322
Rows_affected: 0 Bytes_sent: 3851
Maybe an index is missing or I need to clear some cache somewhere?
I was wondering if other are also having slowness with upgrading an existing database to 1.17-rc4?
Thank you
Jean