Table structure?

Joakim Schramm joakim at astrocalc.com
Mon May 1 21:04:33 CDT 2006


 

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of 
> Ruslan Zasukhin
> Sent: 01 May 2006 20:55
> To: valentina at lists.macserve.net
> Subject: Re: Table structure?
> 
> On 5/1/06 9:15 PM, "Joakim Schramm" <joakim at astrocalc.com> wrote:
> 
> >> It seems you say that it have grow too much ?
> >> But you compare to what ??
> >> 
> > To how it was before with my Primary and Foreign Keys. 
> Before I setup 
> > links I added all data to db including fields for keys, primary and 
> > Foreign. This db is about 55MB. Adding Blinks, two table pairs with 
> > 1:M and one table pair M:M, removing old Primary and 
> foregin keys and compacting db ends at 204MB.
> > A point though, of the M:M I was only able to process about 2000 of 
> > about
> > 207 000 "Owner" records before the demo limit time trow me 
> out, so if 
> > all those was processed db will become enourmous in size.
> > 
> > But it's quite possible I do this in wrong way!
> 
> 200MB this is wrong size.
> 
> Maximum what blink can eat - I have told - 7.4MB.
> But not 200.
> 
> I think Kirill tomorrow can check your COM project.
> Please compress you 11MB text file.
> And give us your VB6 project which build db and import file.
> 
> Okay ?
> 
> If you have some FTP put that stuff there, if no, send it to my email.
> 
I will first have another go at it, so don't bother more now. You already
have put so much time and effort on me - and I am not even your customer YET
(but I am sure I will be).

For me if I can figure it ou myself it's of great value to me.

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
> 



More information about the Valentina mailing list