[rt-users] Closing all open tickets at once

[Swinkels, Marcel]

Hi,

is there a way to close all open tickets directly using SQL? I am
currently testing our RT setup and we have 9855 tickets open at this
moment. Closing them all using the mass-update option in RT takes hours
and causes time-outs while using the webinterface. Is there a way I can
close them all using plain SQL (something like UPDATE Tickets SET
status='closed' WHERE status='open' ?) 

Regards,

Marcel Swinkels
chello abuse
UPC Nederland
abuse at chello.nl