Purge Tickets

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@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

matt.vcf (292 Bytes)

hi mattew,

what you are going to do is EXTREMLY dangerous to the integrety of your
rt-db and as far as i know not supported in any way.
the recomended way to do this, would probably be to upgrade to rt3 and then
use rtx-shredder (http://search.cpan.org/~ruz/RTx-Shredder).

if you want/have to stay with rt2, there is a script that is supposed to do
what you need.

notice:
I’VE NEVER USED IT.
IT MIGHT BREAK YOUR DB.
IT MIGHT BREAK YOUR INSTALLATION FOR ANY FURTHER UPDATES.

you’ve been warned.

if (unsensibly enough) still being interested take a look here:

http://marc.free.net.ph/mbox/20031215.123203.713ec3e1.txt

but don’t ever come and blame me.

good luck

cu
andreas

Andreas Wahlfeldt
subshell GmbH
Margaretenstraße 43a
20357 Hamburg

t +49.40. 431 362-25
f +49.40. 431 362-29
e awahlfeldt(at)subshell.com

Message: 6Date: Tue, 02 Nov 2004 10:24:47 -0600
From: “Matthew D. Stevens” matt@netjam.net
Subject: [rt-users] Purge Tickets
To: rt-users@lists.bestpractical.com
Message-ID: 4187B4CF.8040408@netjam.net
Content-Type: text/plain; charset=“iso-8859-1”

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@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

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

-BrianOn Tue, 02 Nov 2004 10:24:47 -0600, Matthew D. Stevens matt@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@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