Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Bloated Table vs Multiple Joins ?
Message
 
À
09/07/2002 16:12:23
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00676783
Message ID:
00677621
Vues:
23
What about where large number of fields are null? One company uses one field, but theother 20 don't, so for 19 of the companies they have a field that is full of all nulls. Do that for every company, and you have each company with the same table (and a normalized table) but you have 19 fields that are all null but still taking up the space (can't fit as many records into the buffer as a result).

I could keep it as normalized, I would think, if I used the company's name as a primary key, and then joined their customized fields (from another table) to the main table, don't you think?

My boss is definately in your school of thought, but I just think we are taking a huge hit in terms of speed because of the setup. Granted, it would be a hassle and then some to change it all...but if we'd see a 2x jump in speed or something, it might be worth it...

Thus I ask, because I'm not sure when having a few extra fields start to slow things down more then doing a join.

matt
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform