Subject BLOB performance
Author yuraukar
Similar to my varchar question: I am concerned about BLOB performance.
Someone indicated that tables having a BLOB field perform slower. In
fact, the statement was that the whole DB would/could perform slower
if using a single fdb/gdb file.
Is that true? Would I be better off moving the BLOB field into a
separate table or even file?
I have the situation where a table has some "normal" columns which
will always be filled and only in some rare situations, additional
BLOB data will need to be attached. What would be the best design here?