On Wed, Sep 08, 2004 at 07:22:08PM +0100, Chris Ridd wrote:
Is there another way to significantly reduce the database size without losing the data?
If you use the database backend for your attachments, the the attachments stored in article_attachment table. In this table is also a create_time column. So you can just delete attachments older then... by using SQL link "DELETE FROM article_attachment WHERE create_time ...".
Has anyone got a backend which keeps the entire message in an IMAP store? That would IMHO be quite a neat feature :-)
It would be a technical nice feature. But in this case a IMAP box with 1,5 GB isn't fine for the mail server. In my opinion. :) And a database/filesystem is faster then IMAP.
Cheers,
Chris
Martin Edenhofer -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication!