Adding / Closing tickets is very slow
Hello,
We are finding that lately our Service Desk is running quite slowly (Version : 7.5.0 Build 7508)
Adding a contact or in particular closing one takes 5-20 seconds where it used to take 1 perhaps 2.
We are wondering if there is some kind of maintenance or optimization that we should be running on mySQL or alternately if we should migrate the database to one of our SQL 2005 servers.
The server that houses the helpdesk is a reasonable (if single core) machine but it does have plenty of hardrive space and 4 GB of RAM running Server 2003. We did a full defrag of the harddrive and that didn't really seem to help the tickets end of things, though the application did seem to load a little faster.
Thanks
We are finding that lately our Service Desk is running quite slowly (Version : 7.5.0 Build 7508)
Adding a contact or in particular closing one takes 5-20 seconds where it used to take 1 perhaps 2.
We are wondering if there is some kind of maintenance or optimization that we should be running on mySQL or alternately if we should migrate the database to one of our SQL 2005 servers.
The server that houses the helpdesk is a reasonable (if single core) machine but it does have plenty of hardrive space and 4 GB of RAM running Server 2003. We did a full defrag of the harddrive and that didn't really seem to help the tickets end of things, though the application did seem to load a little faster.
Thanks