Originally Posted by rfresh
Can you please clarify:
1. You are storing your email body text in a file system vs a database correct?
2. When you had the body in a database what field data type were you using?
3. Did you index that email body database field or no?
I have an idea but would like to know the above answers please.
Thanks for the reply.. I inherited this system, the email body was stored as a TEXT field, there is currently no index on it in the previous system.
I'm open to using the database to store them, but not sure if having a db with large TEXT fields is efficient.