Thanks Josh, Interesting. I see you use MySQL. Has anyone used SQLite on a single server? I'm curious to know how it performs, it must be really good. Anyway, I'm searching for a web hosting company that offers DBMail and I can't find any in the first 5 search results of Google. Are there any at all? :( Setting up a page on dbmail.org that lists the few companies that offer DBMail would be a good idea, I think. Thanks,
-- Charles A. Landemaine. On 12/6/07, Josh Marshall <[EMAIL PROTECTED]> wrote: > Hi Charles, > > YouTube have very large files, which rarely get modified or deleted, and > the time to transfer between servers doesn't matter. > > Email is very different. If an email comes in on one server, it needs to > be immediately available to all servers, including all the attachments. > > The way that DBMail handles the emails is excellent in my opinion. It > uses constraints so that if an email is deleted, the attachments etc > also get deleted. So no messy code in the software to manage what > attachments are where. > > The problem with having the data split between the database and the > filesystem is that you can't guarantee that any backup is valid unless > you shut the system down or use snapshots. And then you can't do > point-in-time recovery, so any restore from backup you do will lose data. > > From my tests, the DBMail system is quite fast, not as fast at > delivering over network as NFS or locally as direct to the filesystem, > but definitely a lot faster when reading (which is what matters most) as > it can just pull the headers out without having to scan through files. > > Regards, > Josh. _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
