osTicket v1.14.1 - esta muy lento

lauracast

My question is how I can improve the performance of the Osticket, since it is extremely slow and the work is very complicated.
We have this version installed:
osTicket version: v1.14.1 (f1e9e88) — v1.14.8 is available
Web Server Software: Apache/2.4.38 (Debian)
MySQL version: 10.3.39
PHP version: 7.3.19-1_deb10u1
We have 5,000,000 entries, 4,000 entries and 20 simultaneous users enter daily.
We locked the Control Panel and reduced the standard and custom ticket views.
I would like to know how performance can be improved, if any improvements can be configured from the application, and what the optimal configuration of the servers would be to improve response times.
Greetings Laura

KevinTheJedi

lauracast

Upgrade to a latest supported version of osTicket; v1.18.1 or v1.17.5. You are running an old unsupported version.
Upgrading osTicket requires you to upgrade PHP and MySQL/MariaDB which in return brings performance improvements.
Clear storage by deleting unneeded data.
Install a file storage plugin and migrate files from the database to the configured external storage. This clears db storage and speeds up the database.
Provide more resources to the server and database.
Optimize your database.
Scale your platform by setting up a database cluster, etc.

Cheers.

ntozier

PHP8 is much faster that PHP7.