Create Attachments on the local filesystem

Gervase Markham gerv at mozilla.org
Mon Oct 20 22:03:57 UTC 2003


Paul Querna wrote:
> I think this is a bad idea, 

Why? :-)

> It would likely need some cleanup or done to be done in a different way, but i
> don't think storing files in mysql is a good idea, and it gets much slower
> when you have a couple gigs in there.

I think there are a lot of advantages you don't notice to storing 
attachments in the database. For example, greater ease of backup and 
restore or migration from one server to another, the impossibility of 
the attachments and the DB getting out of sync, and their potential 
searchability (we haven't implemented it, but "all attachments checked 
in in the last month which are patches and contain the string 
'wibble.xml'" would be a handy search feature).

Gerv




More information about the developers mailing list