Table structure?

[Joakim Schramm]

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of 
> Ruslan Zasukhin
> Sent: 30 April 2006 17:00
> To: valentina at lists.macserve.net
> Subject: Re: Table structure?
> 
> 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 ?

I create VarChar but Vstudio say String YES, that's it.

I just found a part in kernel doc about Vset and VBitSet and array, so maybe
I can figure it out from there. It's a lot to get into the head!

Joakim
> 
> --
> 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 at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>