Subject | Re: [firebird-support] Space consuming test |
---|---|
Author | Ivan Prenosil |
Post date | 2005-09-02T15:07:28Z |
> The point of this test : lets say we have big table TB_ORDERS > 30milLooking at your new field's name, and considering 0.1% usage,
> records. And we need to add new row ADDITIONAL_COMMENTS (varchar 1600) ,
> which by normalization theory should go into that table. BUT this row
> will be used only for 0.1%.So, this means 99.9% of that coll will be
> used as waste (28bytes * 29700000 ~ 831 MB ). (Of course other solution
> one - to - one ref link)
I would use BLOB. (null blob will consume 2 bytes, or even less
if physically grouped with other zero data on the row)
Ivan