Table structure?

[Ruslan Zasukhin]

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.


-- 
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]