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.

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 :)

Thanks,
CM


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

Hi,

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