ehaerim wrote:

> 1) Can you tell me more how efficient by keeping blobs outside of the main table?

It is not really any more efficient. The blob in main table would only
keep blob ID there - actually blob data is stored on a separate database
page. You would essentially be duplicating what Firebird is already doing.

Depending on the database access library you are using, sure you don't
"SELECT *" but rather name the columns when you don't need the blob.
Some libraries fetch the blob data at once, and this is not what you want.

> 4) BTW, what's YMMV?

Internet jargon: Your Mileage May Vary, i.e. "the above is my opinion,
things may be different in your particular case."

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================