On Tue, 27 Jul 2010 20:33:03 +0200
ronald higgins <ronald.higg...@gmail.com> wrote:
Thanks for the script Garry :)
Unfortunately it's pretty much the same, every delete
taking about 40
seconds, so it doesnt look like adding the SQL logging
in is adding
any overhead :( pitty.
OK, so that rules out overhead on the shredder. How big is your database and
how many tickets are in your system? Im happy to benchmark what the script
does on my RT compared to yours and see where we go.
I can send you my pride and joy, which removes users that send spam, this
combined with removing tickets should shrink your DB and may make life
easier - hopefully you'll have a slow, one off, hit and then a manageable
shred!
You might also want to look at dealing with v large attachments.
Off on hols now. Back 11th Aug - drop me a line if you dont get anywhere
g.bo...@lboro.ac.uk.
Ditto the above, Max
regards
Garry
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
