Hi,

You can use a Generic Agent and select Delete Ticket = Yes at the bottom of your Generic Agent task to delete old tickets from your OTRS.
I don't really know if it will improve a lot your general OTRS speed, it depends mainly on how SQL statements are builds in source code ...
I advise you to make a global mysqldump if you use MySQL before playing with Generic Agent and deleting tickets, then delete and test.
If you see there is no real effect, you can go back with your mysql dump and input back it on your OTRS installation.

You have in Documentation some tips to improve a bit OTRS speed : http://doc.otrs.org/2.2/en/html/c2449.html .

Personnaly I'm skeptic about talking of "speed" under OTRS, this discussion is always coming back :o)
I have always think this software is a good one for all features it offers but it is also *too* slow for my opinion,
there is probably a lot of things to improve for speed in the way it's coded I think.
DB backend were never the problem in all my cases and always though that Perl is the culpit.
PHP/MySQL seems to me solutions easily faster than Perl one for Web applications...

Best regards,

Laurent Minost


Le vendredi 31 août 2007 à 16:57 +0530, pri pri a écrit : 
hi all

i have loads of e-mails in my system and my system has become really slow. i 
am running OTRS on windows server 2003. i would like to know how i can clear 
the database by deleting all the closed tickets. i want to know if this will 
help increase the system speed?

thank you

_________________________________________________________________
"Post ads for free - to sell, rent or even buy.www.yello.in" 
http://ss1.richmedia.in/recurl.asp?pid=186

_______________________________________________
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
Support or consulting for your OTRS system?
=> http://www.otrs.com/