On Mon, Oct 06, 2003 at 02:29:52PM -0600, Jesse Norell wrote: > > > > > 2) move all or larger (>32K) message bodies to disk or at least to a > > > separate > > > table. again, this would dramatically enhance performance where indexes > > > might > > > oitherwise get bogged down on inserting and possibly selecting, and > > > probably > > > speed performance on inbox listings etc as well. (especially full text > > > indexes on the message bodies.) > > > > I'd prefer to keep all the messages in the database. I don't know if > > there would be a significant performance increase. I guess it depends > > on the database/table handler. > > It also makes having multiple pop3/imap servers from the same db > store impossible (without also syncing local filesystem files, which > is ugly).
Good point. One nice thing about dbmail is ability to have one big database server and a number of commodity servers for pop3/imap/smtp.
