Subject | RE: [firebird-support] DB Design Question - include large blob in master table, or separate table |
---|---|
Author | Sasha Matijasic |
Post date | 2008-01-30T09:17:31Z |
Hi
Sasha
> I am about to add a potentially very large blob field to one of mySince you are adding a new feature it would definitely be more advisable to put images in a new table. That way you ensure you will not break any existing code or degrade performance.
> tables for the storing of images for stock items.
>
>Those kind of statements tend to prove false in time. If one image per stock is a requirement it is easy to put constraints into images table and make them 1-on-1 in reference to stock table. If later you decide you need more than one image you can remove constrint.
> There will only ever be one image for each stock item, and images will
> never be shared amongst stock items.
>
Sasha