blob question

[Ruslan Zasukhin]

on 1/27/04 12:16 AM, Greg Kowalski at gregkowalski at earthlink.net wrote:

Hi Greg,

> I have a database with 30.000 records.  Two fields contain strings with an
> average of 3000 characters so I made them blob fields (does that makes
> sense?).  

Do you mean that EACH record have 2 strings
    which in average are 3000 bytes each?

Yes, I think TEXT is good choice then.
Set segment size 1000 bytes.


> The the thing is that .blb file that is created weighs 270 MB.  Does that
> sound right? 

    3000 * 2 * 30,000 = 180MB.

You have 270 extra.

May be you have choose to big segment size for BLOBs.
Try less 


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------