Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Bloated Table vs Multiple Joins ?
Message
 
À
11/07/2002 12:55:07
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00676783
Message ID:
00677693
Vues:
21
>You would definitely waste space if you have unneeded fields.

Yes, that was sort of the crux of my question. The more space you waste the bigger the table. The bigger the table the slower your operations. But, joins are rather costly, so...

>As to the performance, I think the time it takes to execute a query will depend mainly on the number of records retrieved, and (especially for a not-very-optimized expression), the total number of records. But you might want to do some speed tests to confirm whether the total recsize() significantly affects the time it takes for a query, for instance.

Yea, I didn't want to have to dig out my equations, but I guess i'll have to do it anyway.

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

Click here to load this message in the networking platform