Store in mySQL or Files

[Cleverbum@hotmail.com]

I'm creating a page which downloads some data from some other websites
and then processes it. I was wondering if it was better practice to
store the data in SQL Blob fields or temporary files.
For a rough approximation we're talking about approximately 10,000 15kb
files.

[Chung Leong]

Re: Store in mySQL or Files


Cleverbum@hotma il.com wrote:

I'm creating a page which downloads some data from some other websites
and then processes it. I was wondering if it was better practice to
store the data in SQL Blob fields or temporary files.
For a rough approximation we're talking about approximately 10,000 15kb
files.

It's probably better to use a database, since the operation could
potentially fail midway. Storing the constents in a table allows you to
attach meta information like date and such for purpose of recovering
from an interruption. Alternately you could use transactions to ensure
that the operation either succeed or fail completely.