Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to answer negative VFP attitude? Help...
Message
De
19/10/2000 14:46:19
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00427554
Message ID:
00431698
Vues:
13
>Is it considered bad practice to keep the doomahickeys in the same table with the widgets and things, even if there are only a couple of extra fields?

this get's into the art of design - technically it is denormed - but that may be OK - In this situation I take a hard look at several things including how many extra fields there are, how many records will not be .NULL. (how many doomahickeys), and total DB volume.

8 or 10 extra fields or more, tons of records, >50% null ? go with 1-to-1.

A couple fields, few records, and or few null? probably in same table.

I am a big believer in the practical, the flexible, the speedy, and the user-friendly over the "academeic" when there is a conflict.

HTH,
Ken B. Matson
GCom2 Solutions
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform