main logo
Subject: Re: Table structure?
Author: Ruslan Zasukhin
Posted: 2006/04/30 10:00:09
 
View Entire Thread
New Search


On 4/30/06 5:44 PM, "Joakim Schramm" <joakim AT astrocalc DO.T 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]


_______________________________________________
Valentina mailing list
Valentina@lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina

 
©2006 Ruslan Zasukhin
<-- Prior Message New Search Next Message -->