Thanks for the link, it's helped, but hoping for more gains. I've applied the indexes as described and edited the Record.pm and it's knocked the deletes down to 40 seconds per ticket. Which translates to about 115 200 records per day or a week solid to delete my required 700 000 tickets.
Any other other ideas ? Ronald On Tue, Jul 27, 2010 at 3:30 PM, G.Booth <[email protected]> wrote: > Hi Ronald > > You need to add some more indexes to a few of the tables. > > this thread explains all. Think we got to a point where we could shred one > user/ticket every 3-6 secs or so > > http://lists.fsck.com/pipermail/rt-users/2009-November/062395.html > > hope it helps > > regards > Garry > > -- > > Dr Garry Booth > IT Services > Loughborough University > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
