On Tue, Jan 29, 2008 at 03:49:10PM +0000, Mark Rogers wrote: > Alex Tomlins wrote: >> By database I was thinking whatever database backend dspam was using >> (hash, mysql, postgres etc.), not specifically a RDBMS. While >> implementing this it would make sense to put the user logs in there as >> well. The advantage to doing this is that all the data for dspam would be >> in one place as opposed to the current setup where some of it is in a >> database, and some of it is on the filesystem. >> > > OK, I see your point. However, I'm not sure suited how well a hash database > would be for storing quarantine emails - or, for that matter, even a RDBMS. > Logging to a RDBMS would be helpful given how much processing we do of > dspam log files, but in most cases that can be improved simply through > better ways of handling the text files. > > I'm strongly of the opinion that mbox is horrible, but which alternative is > best I'm open to suggestion on. >
Also, storing files in an SQL database has a much, much higher system resource footprint then using the filesystem, which is already optimized for file storage. I concur that mbox is a poor alternative, but a maildir option should be suitable. Ken