Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
When does Rushmore Optimize?
Message
From
03/11/1998 11:10:12
Paul Harker
Harker Enterprises, Inc.
Idaho Falls, Idaho, United States
 
 
To
02/11/1998 22:25:16
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00153608
Message ID:
00153953
Views:
16
I called MS on the join speed issue back on VFP 3.0. The issue is when you perform a join, EVERY record is checked against EVERY record in EVERY database involved in the join. If you are checking against more than 2 databases, the join gets longer expodentially be each additional database. I still code all my join/datacross checking functions because they are ALWAYS faster than a join. My .02
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform