Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How does TOP work?
Message
From
19/11/2008 14:42:30
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01362672
Message ID:
01362914
Views:
21
Dang.. I missed that. As usual, you've pulled the answer out of the ether.

>Before VFP9, yes. In VFP9, it depends. From VFP9 help:
>
>"In Visual FoxPro 9.0, performance has been improved by eliminating records that do not qualify for the TOP N from the sort process as early as possible.
>
>The TOP N optimization is done only if the SET ENGINEBEHAVIOR Command is set to 90".
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform