Posted by Chung Leong on 10/13/06 18:41

Cleverbum@hotmail.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.

[Back to original message]