> > I have only changed the maxsize of VarChar to smaller
> values, but most
> > of them will go as I remove the keys. I have some of these now as 4
> > char strings.
>
> 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.
Joakim
Joakim
> > I know try to find out how I can iterate a BitSet returned from
> > FindValue - but I guess it's somewere in the manual, so am
> looking for it.
>
> --
> 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.O.T 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 |
