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

> I have two intentions over here:
> 1) My window will have 2 tabs. Main tab is to display details which coming
from main table. Second tab is to display picture or memo. Only when user
clicks on second tab then only I select from the separate BLOB table using
the main ID. Most of the time user will not go into second tab.

You can do this easily by not including the BLOB columns in your first tab
and by executing a separate query from your table when the user goes to the
tab, no need for a separate table.

> 2) I would assume this design will have benefit of more compact data
storage on the data page. I am not 100% sure on this one :)

Only (very) small blobs will be put on the same datapages as the normal
data, the rest of the blobs goes into separate blob pages inside the

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