> > 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). -- Jesse Norell jesse (at) kci.net
