Re: [otrs] Shrink database

ok, thanks Ralf, I will try it out. marc 2009/8/19 Ralf Hildebrandt :

* Ralf Hildebrandt :

...

* Mercator GmbH :

...

deleting old tickets takes me DAYS or even weeks!!

Why? I just use a generic agent to do that. I specify a time range and delete the really old, closed tickets.

I just performed that here and it takes about 1s per ticket. It even times out, so I have to repeat the process...

-- Ralf Hildebrandt  Geschäftsbereich IT | Abteilung Netzwerk  Charité - Universitätsmedizin Berlin  Campus Benjamin Franklin  Hindenburgdamm 30 | D-12203 Berlin  Tel. +49 30 450 570 155 | Fax: +49 30 450 570 962  ralf.hildebrandt@charite.de | http://www.charite.de

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/