Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is 78 fields per table too much??
Message
 
À
15/06/2004 07:34:32
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00913804
Message ID:
00913851
Vues:
11
Instead of flattening it out, which is what you sounds like you are thinking of doing, make it record based by some sort of code. Then you will never have to change the number of fields in the table, just add another set of records (13 fields).
iKey  cType  xF1 - xF13
1     A1
2     A1
3     A1
4     A1
5     A1
6     A1
7     A2
8     A2
9     A2
10    A2
11    A2
12    A2
13    A2
A2 is a set of 7, A1 is a set of 6.

-w-

>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
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform