Jim C. Nasby wrote:
On Sat, Jun 10, 2006 at 01:23:35PM -0600, qqqq wrote:
I would defer to the smart people to figure out the details. However I do
wonder if the actual body content of the message would be best stored in a
file and the SQL used to store anything and everything you would want to
index. That would keep the SQL file size down if that's an issue. However,
SQL databases might have to be changed to accomodate the needs to store
email.
I think this is what I was getting at early in the thread. I would think
that a 5 MB body would do better on file but I don't know enough in regards
to DBs to even make a call.
A good rule of thumb about storing something in the database is: are you
going to search that data? If you're going to search the text of an
email body, that makes it a more likely candidate for storing it in the
database (though there are ways to do this searching while storing the
file externally).
SQL databases suck dead dogs through a straw on full text searches. The
language specification isn't designed for it. Database vendors offer
support for it in various mutually-incompatible ways.
It's easy to precalc search indices for maildir and produce fast search
results; mairix is one such tool that I know of, there are no doubt many
other solutions available.
David
--
Much of the propaganda that passes for news in our own society is given
to immobilising and pacifying people and diverting them from the idea
that they can confront power. -- John Pilger
