Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2007
    Posts
    2

    Unanswered: Storing emails on database

    As a DBA I'm helping a development team to design a new application. One of the requisites is that the emails sended by the application must be saved for 3 months and I'm doubt if is a good idea to store this emails on the database instead of on a file system but I'd like to know your opinion and experiences about that.

    Tks.
    Regards,
    Ronald.

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    store the emails in the database. when the database is properly tuned and the tables indexed correctly, mysql can seemlessly handle in the tens of millions of rows and more.

  3. #3
    Join Date
    Feb 2007
    Posts
    2
    Thank you for your help. How did you do that? Using varbinary or blob, myisam or innodb?

    Regards,
    Ronald

  4. #4
    Join Date
    Mar 2004
    Posts
    480
    if you need transactions then use innodb otherwise myisam is fine.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •