Reynald I. Ngo said: > At 04:40 PM 1/15/2003 +0800, Orlando Andico wrote: > > I read once that having an database as your mail storage is a > single point of failure. Notice nobody in the open source community > implemented such although most of the MTA can be customized to use > database as the backend (on your discretion of course). You can > implement your configuration and lookup tables though without > problems.
hmm...maybe because maildirs or similar implementations can do the job more efficiently? IMAP has a search feature so there's no need to implement one yourself using SELECT * FROM whatever LIKE '%' queries or such. besides...it's not really convenient having large objects inside your database. i've only used open source db servers extensively and it's not really good to store big objects (e.g. mail, with all your attachments and stuff) inside it. mysql performance degrades big time. i don't know what's the case with enterprise-strength stuff like oracle. most design guides point to storing binary data as much as possible in the filesystem, instead of the database. (of course there are some applications wherein storing binary data in the db is better but maybe mail storage isn't one of them :P) -dre _ Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] Fully Searchable Archives With Friendly Web Interface at http://marc.free.net.ph To subscribe to the Linux Newbies' List: send "subscribe" in the body to [EMAIL PROTECTED]
