Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is 78 fields per table too much??
Message
From
15/06/2004 08:05:37
 
 
To
15/06/2004 07:34:32
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00913804
Message ID:
00913818
Views:
11
That's a tough one to reply too.

You'd have to give us the name of the fields. What is going to be stored in those fields. Relations with fields in other tables.

Just by knowing that there are 78 fields is not enough. Without the big picture I don't see how anybody could answer this one way or another.

For a starter:

Define entities and sets? What do those mean?

>I am building an additional table (.DBF) for my VFP8 application. I'm trying to normalize, de-normalize to maxium efficiency. If this data does not need to be split up (normalized) between 2 or more tables, I'd prefer keeping it in one table. I'll have at least 78 fields (13 distinct entities times a multiple; eg. 6 sets = 13 * 6; 7 sets = 13 * 7, etc.)
>
>Thanks,
>
>dbk
*******************************************************
Save a tree, eat a beaver.
Denis Chassé
Previous
Reply
Map
View

Click here to load this message in the networking platform