Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sub queries or separate SELECTs?
Message
From
23/09/2005 19:07:09
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Sub queries or separate SELECTs?
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01052615
Message ID:
01052615
Views:
43
Hi,

Is there a speed advantage to using separate SELECT commands as opposed to humping them up into a single command using sub queries?

Here's an example of what I'm refering to:
SELECT Field1,CNT(*) as nTotal FROM ATable INTO CURSOR crsCursor1 GROUP BY Field1

SELECT nTotal FROM crsCursor1 INTO CURSOR crsCursor2
as opposed to
SELECT nTotal FROM (SELECT Field1,CNT(*) as nTotal FROM ATable GROUP BY Field1) INTO CURSOR crsCursor2
The first example is more of a pain to clean up after but is easier to debug. I'm just wondering if there is a runtime speed advantage to any of them.

Aloha,

James
Next
Reply
Map
View

Click here to load this message in the networking platform