Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speed difference
Message
From
04/03/2004 17:13:57
 
 
To
04/03/2004 16:39:47
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00883280
Message ID:
00883291
Views:
6
The first one will be faster because if it find that Field1 not = "1" then it wont evaluate the second part of the condition. Alos in the second choice, it will evaluate if Field1 = "1" twice.

Keep in mind that would make a significant difference only if the table is very big and if it happens often that Field1 not = "1"
Diane Robitaille eng.
Previous
Reply
Map
View

Click here to load this message in the networking platform