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 |