Subject Re: [firebird-support] Table Design Involving BLOB
Author Martijn Tonies

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

None, there could be some benefit, but only if you do SELECT * always, which
you shouldn't
be doing anyway.

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

What's your intention?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
My thoughts:
Database development questions? Check the forum!