[rt-users] Purge Tickets

[brianBOFH]

Hi Matthew,

40,000 tickets is a fairly small installation.  You will find that
creating some indices will speed things up greatly. Check out
http://lists.bestpractical.com/pipermail/rt-users/2001-August/003824.html

-Brian



On Tue, 02 Nov 2004 10:24:47 -0600, Matthew D. Stevens <matt at netjam.net> wrote:
> Hello!
> 
> I use a RT2 system with approximately 40,000 tickets.  The system has
> become extremely slow so I would like to purge all of the tickets and
> only keep tickets from 1 year ago to present.  I'm not quite sure how to
> do this so any help or suggestions would be much appreciated.
> 
> Thanks,
> 
> Matthew
> 
> --
> --
> Matthew D. Stevens
> matt at netjam.net
> Sales and Purchasing
> 
> Netjam, LLC               http://www.netjam.net
> 333 Texas St.             VISA/MC/AMEX/COD
> Suite 1401                90 day warranty
> Shreveport, LA 71101      Cisco Channel Partner
> 
> p: 318-212-0245
> f: 318-212-0246
> Toll Free: 866-2-NETJAM
> AIM: Matt at Netjam
> 
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT wiki at http://wiki.bestpractical.com
> 
> 
>