Subject Table Design Involving BLOB
Author chee hee
Hi All,

I have few tables which have data from hundred thousand of records to millions of records.
All these tables either have BLOB subtype 0 or 1.

My question is there any benefit to move these BLOB columns out of the main tables?
For example, I will create 2 respective BLOB tables (one table for BLOB subtype 0 and another table for BLOB subtype 1).
And this BLOB table will only have 2 columns (ID and BLOB) and the ID will point back to main tables.

Any comment of the above design?


Send instant messages to your online friends

[Non-text portions of this message have been removed]