Application Data Storage Question

[<operationsengineer1(at)yahoo(dot)com>]

I'm working on an application that will need to store
all sent and received emails in logical groupings - in
my case, each transaction will have an email history
associated with it.

i can conceive of two ways to store the email data.

1. stick all pertinent email info in a db linked to
the transaction id.
2. create a transaction id directory in the file
system and store a file for each email sent/received
with all the pertinent info within that file.

the user needs this functionality to provide an
archive of the transaction.

i'm not experienced enough to know the pros and cons
of either process, or if there is a better process i
haven't thought of.

tia...


 
____________________________________________________________________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com