Table structure?

[Ruslan Zasukhin]

On 4/30/06 5:44 PM, "Joakim Schramm" <joakim at astrocalc.com> wrote:

>> Deal is that maxsize of VarChar DO NOT make smaller db.
>> IT is just logical limit which work on INSERT
>>  
> Are you sure? It was by changing maxsize from default 1022 in all VarChar's
> to 4 for some and 60 to some size of db went down from 1.8 GB to 50 MB!
> However, when I tested and set back 1022 it didn't increase db again.
> Except, if I left old db and again created my structure and imported - that
> increased it lots so maybe there is a bug here somewere?
> 
> I used to delete files before creating new db for test but I might forgot
> some time, giving base for db growing so big. I don't know, it just
> happened.

We nee check this. May be VCOM have but and instead of VarChar it create
String.

Please check this in Valentina Studio.

What types of fields you see ?

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