Milan B. wrote:
<<
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.

>>

Milan, isn't it so that "small" blobs are stored on database pages
with the rest of the record?
I haven't seen any authoritative numbers on this, but as best as I
can remember the advice given in a session at the Luxembourg
conference was that keeping blobs in separate tables was (could be?)
a good thing.
As I wrote, (with Firebird) I never bothered to do the split.


As for "YMMV", it is often used when giving an estimate on how many
miles a car can run on a gallon of petrol - Your Milage May Vary.

--
Aage J.