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