Data compression issue for Valentina 2.0 Beta

[Ruslan Zasukhin]

On 11/22/05 8:16 AM, "김 광열"  wrote:

> We feel it is almost same speed with 1.0.


> I have questions.
> We are trying to load another test file and we come to know there is big
> differences
> according to the number of null columns.

> Let's suppose there are A, B, C, D columns in a table and we are just using
> A,B columns.

> In this case, is Valentina requiring disk space for C, D, though we didn't
> give values for them?

In general yes. 

    Numeric fields, String[N]  -- eat bytes as declared.

    VarChar eats 8 bytes only.

    empty BLOB/Text field eat 4 bytes.


> And we'd like to know whether the length of column name can affect the size of
> database files or not ?

Name of column? Of course no. it is stored once in .vdb file.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]