[rt-users] Archiving old tickets

[Daniel F. Chief Security Engineer -]

On Friday 31 January 2003 11:39, Vivek Khera wrote:
> >>>>> "SC" == Seth Cohn <Seth> writes:
> >>
> >> If someone does have a way of archiving older tickets it would be nice,
> >> for both space, and search speed.
>
> SC> Make your searches have a default "after X date"... that would limit
> the SC> SQL query a lot... probably greatly increase speed, without having
> to SC> touch the DB.

As far as I can tell there is no indexing so the above does not work. 
Especially if you have to search history/ Attachments for some keep word. 

I need to be able to remove tickets that are old with out damaging the 
database. 

Thanks

>
> Only if it were indexed by date, or does mysql have some other magic
> in it?
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
>
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm