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.

Thanks,
CM


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

Hi,

> 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
query
and by executing a separate query from your table when the user goes to the
second
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
table
data, the rest of the blobs goes into separate blob pages inside the
database.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene. com
My thoughts:
http://blog. upscene.com/ martijn/
Database development questions? Check the forum!
http://www.database developmentforum .com




Send instant messages to your online friends http://uk.messenger.yahoo.com

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