Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Optimizable expressions
Message
From
22/03/1999 13:46:30
Walter Meester
HoogkarspelNetherlands
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00200386
Message ID:
00200594
Views:
10
Christof,

>1. LIST FOR id = 'X' AND DELETED()

>2. LIST FOR DELETED() AND id = 'X'


>When you have an index on DELETED() and ID, both should take the same time. If you don't have an index, the second one should be faster, because only in 50 cases the expression ID="X" has to be evaluated.

From the theory you're right, but since the most time would be spend by getting the actual records into memory, in practice there would be no significant difference as it don't take much time to evaluate both of the expressions.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform