Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Relationships vs SQL
Message
From
12/08/2004 16:19:50
 
 
To
12/08/2004 09:25:44
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00932669
Message ID:
00932931
Views:
14
I wrote a set of performance tests for VFP team for version 8.0. The result showed that SQL statement out performed the Relation statement in most cases. Sometimes by a factor of 4 to 5 times faster.

>I can easily use either one to display information on a form and in reports, but is there a compelling reason to choose one over the other? Are there situations where one is better than another? Most of our primary application does not use relationships, but I'm creating a new module where it looks to me it could be useful.
Greg Reichert
Previous
Reply
Map
View

Click here to load this message in the networking platform