Hello. We’ve been running RT for awhile here internally and the database
is starting to really get sluggish. Does anyone have a script to archive
out tickets that are over x months old and closed?
thanks
Mark
Mark Steiger Systems Administrator
651-604-7890 Veritas Software
"A computer system without Microsoft products is
like a dog without bricks chained to its head."
–David Wagle
What version of mysql are you using? What version of RT are you using?
A first step is to add a few indexes, which will greatly increase performance
As far as I know, nobody’s built the data migration / archiving tools yet.
That’s one of those things that I might be willing to take on if a specific
client had an interest in making it happen.
jesseOn Thu, May 11, 2000 at 02:55:13PM -0500, Mark Steiger wrote:
Hello. We’ve been running RT for awhile here internally and the database
is starting to really get sluggish. Does anyone have a script to archive
out tickets that are over x months old and closed?thanks
Mark
Mark Steiger Systems Administrator
651-604-7890 Veritas Software
“A computer system without Microsoft products is
like a dog without bricks chained to its head.”
–David Wagle
rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users
jesse reed vincent – jrvincent@wesleyan.edu – jesse@fsck.com
pgp keyprint: 50 41 9C 03 D0 BC BC C8 2C B9 77 26 6F E1 EB 91
sage will enter into a period of
indentured servitude which will last for a period of time no less than seven
years.