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