jvogt
Usually slowness means a lot of data but non-optimized database and/or not enough resources to keep up with the growing data set. Best approach to keep all data and keep the system fast is to increase the resources for MySQL and/or optimize the database.
If you instead want to take the approach of deleting old data it’s best to do so from the User Directory. You can delete a User and check the box to delete all associated Tickets and data. This will go through and delete all the related records, etc. in one go. However this is done manually per-user. Other than that you can do it via the database however there are tons of related records, etc. for each object (User, Ticket, Thread, Form Entry, etc.). So it will be more complicated doing it from the database.
Good news is in v2.0 we are looking to add an Archiving feature (manual and automated) which will help in these cases.
Cheers.
