Store in mySQL or Files

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
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

Re: Store in mySQL or Files wrote:
Quoted text here. Click to load it

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.

Site Timeline