Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Simple Denormalized vs Normalized Example
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00308138
Message ID:
00310839
Views:
36
>You made many statements; I am disputing the one that is about performance. Do I need to start a new thread to discuss this?

Carl,

And I have said the scenario was hypothetical in my first reply to you. Please review hypothetical, that means made up with its own set of rules.

If you want to run tests to see if two table access is faster or slower than single table access that is a different thread.

BTW, empirical testing shows that a two table relation is about the same speed as a single table (when the tables are on the local machine), but an SQL Select takes longer than those two because the query has to run in addition to processing the records.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform