Table structure?

[Joakim Schramm]

Ahh now it start to look like something!

I tested removing key field as if I have added Binary Links, and import was
very fast, less then 1 minute AND db only 42Mb :-)

Now we are in bisiness my fiend!

Joakim

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of 
> Joakim Schramm
> Sent: 29 April 2006 23:31
> To: 'Valentina Developers'
> Subject: RE: Table structure?
> 
> > 
> > Db size is wrong....
> > 
> > Well, in latest 2.3.1  Valentina Studio you can see size of 
> separate 
> > table and even field.
> > 
> > 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..
> > 
> Changed Maxsize of VarChar, all except 2 to 4 and the 2 to 
> 100, 2 short changed to Byte.
> 
> Db now 539 MB, but that still rediculus big, or do Valentina 
> create BIG size db's?
> 
> Will test compression, but were most effective and best performance?
> 
> Have you consider 7zip for compression? It's Open Source and 
> very effective, you see my figures before about half size of RAR.
> 
> 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
> > 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>