On Monday 27 November 2006 01:41, operationsengineer1(at)yahoo(dot)com wrote:
> 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.
It sounds like you have storage and retrieval needs based on an index. Why
not use the database?
In response to
pgsql-novice by date
|Next:||From: operationsengineer1||Date: 2006-11-27 15:55:05|
|Subject: Re: Application Data Storage Question|
|Previous:||From: Tom Allison||Date: 2006-11-27 11:24:40|
|Subject: Re: Benchmarking PostgreSQL against others on Windows?|