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

Reply via email to