[rt-users] Archiving old tickets

[Seth Cohn, EFN General Manager]

On Fri, 31 Jan 2003, Bruce wrote:

> At 11:27 AM 1/29/2003 -0600, you wrote:
> >Anyone know how to do this and still be able to search them. Or would that be
> >a mysql thing.
> 
> Im quite intrested in this too, we have tickets from around 1997, and when 
> anyone of the support team do a search for somthing MySQL starts to chug 
> away and eat the server load for about 5 minutes because of all the old 
> tickets.
> 
> If someone does have a way of archiving older tickets it would be nice, for 
> both space, and search speed.

Make your searches have a default "after X date"... that would limit the
SQL query a lot... probably greatly increase speed, without having to
touch the DB.