Subject Re: [firebird-support] Table Design Involving BLOB
Author chee hee
Martijn, Thanks a lot.
Initially I thaught blob will fragmented my main table datapage.
Now I understand the the blob data storage (only blobid) and I will make the blob column inside main table.

Can you comment something on SEGMENT SIZE.
What is the optimal SEGMENT SIZE for subtype 0 and subtype 1.
My database page size is 8K.


----- Original Message ----
From: Martijn Tonies <m.tonies@...>
Sent: Thursday, August 2, 2007 3:13:54 PM
Subject: Re: [firebird-support] Table Design Involving BLOB


> 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
http://www.upscene. com
My thoughts:
http://blog. martijn/
Database development questions? Check the forum!
http://www.database developmentforum .com

Send instant messages to your online friends

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