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