Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bloated Table vs Multiple Joins ?
Message
 
To
11/07/2002 12:55:07
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00676783
Message ID:
00677693
Views:
19
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform