main logo
Subject: RE: Table structure?
Author: "Joakim Schramm"
Posted: 2006/04/30 10:04:03
 
View Entire Thread
New Search




> -----Original Message-----
> From: valentina-bounces /at/ lists D.OT macserve.net
> [mailto:valentina-bounces@lists.macserve.net] On Behalf Of
> Ruslan Zasukhin
> Sent: 30 April 2006 17:00
> To: valentina /at/ lists D.OT macserve.net
> Subject: Re: Table structure?
>
> On 4/30/06 5:44 PM, "Joakim Schramm" <joakim@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 D.OT macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>

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

 
©2006 Joakim Schramm
<-- Prior Message New Search Next Message -->