Hi all,
Since a few weeks we have the problem, that it takes very long to display all closed tickets (>1 min.).
This issue came not creeping. It started suddenly, after implementing some changes:
- Added new helptopic / changed several tickets to this topic
- Added custom form field with new list (entries)
- Added two new view pages (queues) and a new column with sorting (I rolled this back today - but problem persists)
Some data:
- Win Server 2016 (virtual; 16 GB RAM / 8 cores)
- Xampp 3.2.4
- Apache 2.4.41 x64
- PHP 7.2.28
- phpMyAdmin 5.0.1
- osTicket 1.15.4 Patch-1
- osticket database 265k entries / 1.4 GiB size overall
- all tables are InnoDB-tables
Do you have any ideas? Thank you in advance!