[rt-users] Archiving old tickets

[Daniel F. Chief Security Engineer -]

I was hoping to be able to reduce the size of my Attachments table, it's 4gig 
and growing in under 6 months. 

I guess speed is my biggest issue now. The machine im running it on is a dual 
PIII 1.3 Ghz and 2Gig of ram. On an IDE disk. Im considring more ram and SCSI 
drives in a raid config. Although it seems some thing on the machine has a 
memory leak as it eats up all the memory and will not release till a reboot. 

I get about 200 new tickets a day. 

TIA 


On Wednesday 29 January 2003 17:29, Matthew Watson wrote:
> What is it that you actually hope to achieve by archiving thme?
>
> Speed ? , Disk Space ? or purely just a "cleaner" result? (eg not as many
> tickets return on the search page?)
>
>
>
> --On Wednesday, 29 January 2003 11:27 AM -0600 "Daniel F. Chief Security
>
> Engineer -" <danielf at supportteam.net> wrote:
> > Anyone know how to do this and still be able to search them. Or would
> > that be  a mysql thing.
> >
> > Thanks
> >
> >
> > --
> > Daniel Fairchild - Chief Security Engineer | danielf at supportteam.net
> > _______________________________________________
> > 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
>
> _______________________________________________
> 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

-- 
Daniel Fairchild - Chief Security Engineer | danielf at supportteam.net
The distance between nothing and infinity is always the same no matter how 
close you get to nothing.