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: 29 April 2006 23:02
> To: valentina at lists.macserve.net
> Subject: Re: Table structure?
> 
> On 4/29/06 11:48 PM, "Joakim Schramm" <joakim at astrocalc.com> wrote:
> 
> > 
> > Some statistics:
> > 
> > Roughly 4min 20sec 459965 records added, including creation 
> of db and 
> > structure. But db size 1.73 GB! Of which index 16.5 Mb and 
> data 1.72 
> > GB, NoLog.
> > 
> > RAR 7060Kb
> > ZIP 10879 Kb (With RAR)
> > 7z  4537kb
> > 
> > All normal compression, whole db 4 files.
> 
> Db size is wrong....

Yes it sure must be!

> 
> Well, in latest 2.3.1  Valentina Studio you can see size of 
> separate table and even field.
> 
I have 2.3 fc18 - is that the one?

> To see easy all sizes in top bar, at left you can see 2 buttons.
> Switch to Tree View. And here find who eat space..
> 
How can I see size? I see field Length in tree view but always 0 or empty,
and in property dialog Length of String sometime 1022, that's Maxsize
varChald set to. I will try reduce and see it that changes, maybe also test
compact - but is that compression or just "cleaning"?

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
>