[rt-users] Mass Delete

[Torsten Brumm]

Hi,

like stephen said, use rtx-shredder and do this from the CLI, this is
faster, much faster ;-)

Torsten

2007/1/23, slushpupie at gmail.com <slushpupie at gmail.com>:
>
> I have a queue with over 15K spam messages in it, and I want to delete
> every one of those messages.  Using the bulk update for this really
> isn't feasible at 100 per page, and the browser runs out of memory if
> I do unlimited.
>
> There are no other tickets in the queue, so I thought this might be a
> chance to just do some SQL queries directly on the database.  But I
> want to be as safe about it as I can be.  I can do a query like this:
>
> update tickets set status = 'deleted' where queue = 42
>
> (42 is the numeric id of the queue in question)
> But this dosnt update the transactions table.  Is that safe? It also
> seems kind of wasteful to keep all that data around when we have no
> need for it, so removing things from the attachments table popped into
> my head, but I wasnt sure how good of an idea that was either.
>
> Has anyone ever had to deal with this? Whats the best way to move forward?
>
> Jay
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>



-- 
MFG

Torsten Brumm

http://www.torsten-brumm.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070124/bd7c4e83/attachment.htm>