Hello Eugene, that process is slow as you mention, when deleting it has to go into several tables and delete all relations between objects before deleting objects. If you are deleting all tickets and everything in the system then the best way is to drop database and create it again, otherwise best thing is wait, depending on the configuration of your machine that might take you about 10-15 hours,

Best thing to do is configure generic agent to run every 10 o 20 minutes. It deletes about 4000 tickets each round.

Regards.

2015-11-20 7:32 GMT-06:00 Eugene Polyanichko <messiah@nline.net.ua>:
Hi,

i'm using old otrs 3.1.7 and there is around 170k tickets, that I need to delete. I'm using generic agent, but the process is VERY slow. It takes around 5-10 second to delete one ticket and there is actually no load on hardware (load average: 0.25, 0.20, 0.12), everything is idle. Are there any ways to make this process faster?
---------------------------------------------------------------------
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



--
Alvaro Cordero Retana
Consultor de Tecnologias
Tel: 22585757 ext 123