V4MD 1.10

Ruslan Zasukhin sunshine at public.kherson.ua
Wed Jan 28 10:41:55 CST 2004


on 1/27/04 3:14 PM, Roland Hildebrandt at r.hildebrandt at sbt.fr wrote:

> Hi Ruslan !
> 
> It seems the problem depends of the type of field :
> 
> Long : (!) Table has X physical records but field has 256
> Byte :  (!) Table has X physical records but field has 1024
> Datetime:  (!) Table has X physical records but field has 128
> String :  (!) Table has X physical records but field has (depend of string
> length)
> Float :  (!) Table has X physical records but field has 256
> 
> Where X is the number of records created in the table.
> 
> Varchar fields never has this problem.

Yes, because VarChar itself is aligned to 1KB always.

> I think it will work all right for boolean fields but I haven't tested it.
> 
> It seems this is linked with the segment size ??? In fact we use a quite
> small segment size : 1024 when creating our bases because we need them to
> use few disk space and we have a lot (often more than 50) of fields in each
> table.

Segment of what?
    db or BLOB ?

For DB that is too small.
Min 2KB I recommend.


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



More information about the Valentina mailing list