> > 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.


Nigel Weeks
Tech Support & Systems Developer
Rural Press Tasmania
The Examiner Newspaper
71-75 Paterson St
Launceston Tas 7250
Ph. 03 6336 7234
Mob. 0408 133 738

IMPORTANT NOTICE - The contents of this e-mail may be confidential and is
intended only for the individual(s) or entity(s) named herein. Any
unauthorised use of the contents is expressly prohibited. If you have
received the e-mail in error, please contact the sender by telephone
immediately and then delete the e-mail. We cannot guarantee that this
e-mail, attachments or Internet links are free of computer viruses that may
damage or interfere with data, hardware or software or contains material
that may contravene local, national or International laws. Opening of this
e-mail is acceptance on the part of the recipient(s) that he or she accepts
full responsibility for protecting their computer and associated software
and systems from any such viruses and materials and absolves Rural Press
Ltd.