Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Which is faster?
Message
From
26/03/2000 04:00:21
Walter Meester
HoogkarspelNetherlands
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00350395
Message ID:
00350503
Views:
23
Steve,

>I found out that the SQL SELECT is much faster than the SET FILTER in my testing today.

Watch out with this conclusion. It heavely depends on the selectivity of the query. If SQL is used to filter out a small set out of a large table, SQL is the clear winner here. However if you want to filter out only a small percentage of the (large) table SQL isn't worth the cost: use a SET FILTER instead.

Walter,
Previous
Reply
Map
View

Click here to load this message in the networking platform