Benji_
asked on
Storing Emails in a DB
Hello,
I am wondering what the best way to store information is.. we have a script that downloads mail from an IMAP server at set intervals.
We need to store the To, From, Date/time, Body (HTML),Body (Plain Text), Company ID
I have been browsing the best way whether Mysql / DynamoDB NoSQL kind of solution is best.
What would you guys advise to be a way to store this information for read access.
If so what field types would be the best to use?
Regards
Ben
I am wondering what the best way to store information is.. we have a script that downloads mail from an IMAP server at set intervals.
We need to store the To, From, Date/time, Body (HTML),Body (Plain Text), Company ID
I have been browsing the best way whether Mysql / DynamoDB NoSQL kind of solution is best.
What would you guys advise to be a way to store this information for read access.
If so what field types would be the best to use?
Regards
Ben
How will you enter the values?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hey,
Data will be entered via a PHP script on a cronjob.
Body of that data could be above 64k, We will be storing around 150k+ emails in the DB.
Data will be entered via a PHP script on a cronjob.
Body of that data could be above 64k, We will be storing around 150k+ emails in the DB.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.