In a self-hosted Frappe Helpdesk. Recently, I have been facing slowness in the ticketing portal.
Just I have upgraded my hardware configuration:
- RAM: 24 GB
- CPU Cores: 8
- Disk Size: 500 GiB
To improve DB performance, I am planning to perform the Indexing to the following tables:
- tabHD Ticket
- tabCommunication
- tabComment
- tabHDService Level Agreement
- tabAssignment Rule
- tabVersion
- tabActivity Log
Did I Missed any important tables here?
Also, could someone share the recommended steps or best practices for DB optimization, or suggest any other performance-improvement techniques?