Hi Timo, On Tue, Sep 07, 2004 at 12:43:05PM +0200, Timo Eckert wrote:
how can I archive old Message in the Database, without destruct the structure of the Databasse?
Because orts runs here on a p3-700 and the database is now over 100MB. This slows down otrs, so I want to archive old Messages, I dont need anymore.
Normally a 100MB Database should not slow down you database. Read also: http://doc.otrs.org/1.2/en/html/performance-tuning.html Anyway, there is no way to archive old message by otrs because normally a system can have ~30.000 tickets without performace changes. If a system have ~150.000 tickets, then you should use the OTRS performance tips. However. You can dump/backup your database and after that you can detele ticket (with generic agent) from your database.
Regards, Timo.
Martin Edenhofer -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication!