>>>> You can put pretty much anything you like in a BLOB field, but
> the usual
>>>> method is to put a filename in a VARCHAR, and keep the file on your
>>>> filesystem, rather than slow down your DB pulling data from BLOB's.
>>> That's a very broad statement to make and I disagree :-)
>> I'd love to know why you disagree! I've probably been doing things
> wrongly
>> for the last 5 years...
>> I feel another learning curve coming on...:-)
>>
>> It's true I was assuming that only files were to be stored, and with
> PHP, it
>> takes two database operations to pull data from a blob(one to get blob
>> reference, the second to visit that reference and pull the data)
>> Sure, it's all done automatically with
>> `ibase_fetch_object($recordset,IBASE_FETCH_BLOBS)`, but behind the
> scenes,
>> there's still extra traffic.
>>
>> Keen to learn, so bring it on...
>>
>> Nige.
>
>
> I would agree with Martijn in the sense that it is a very broad
> statement, however in many cases it is true. Both methodologies have
> different advantages.
>
> Store inside database:
>
> Pros:
> Single file backup
> Can be sure the data exists

And an important one, at least for me, is transactional support.


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com