Martin Edenhofer wrote:
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.
If you've already got your messages in an IMAP store then it would make a lot of sense to keep them there. I only want one copy of 1.5GB of mail, thank you :-) The additional protocol overhead of an IMAP connection might be a concern, but might be similar to a DB connection if the store and DB are co-located. Is writing new ArticleStorage classes documented anywhere? The existing ArticleStorage classes don't seem to share a superclass or anything. Cheers, Chris