Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT speed depends on output size questions ??
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00187003
Message ID:
00187056
Views:
26
I agree with Ed's first point. VFP is taking all the time building the result set on disk. I'm curious, if you change the query to just return the count of the rows in the result set (COUNT(*)) does it still take as long?

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform