We run a smallish forum but it has been around for a long time and thus, the SQL db is large and since we are small, we are on a budget host site. Looking to improve the SQL query speed. Any advice to get us pointed in the right direction would be greatly appreciated.
Some questions along this line that we have already had:
- does closing old threads improve query response time?
- is there any optimizations we can do to the DB?
- if we wanted to archive off all the old threads, how would we go about this?