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.
