Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SCAN vs. SELECT???
Message
From
21/09/1998 14:35:14
 
 
To
21/09/1998 14:33:37
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00139130
Message ID:
00139182
Views:
34
Yes....ROFLMAO ... I guess it would be!!!!

>Do you mean setting remote view on whole table and then SCAN it? In Russian, it's called touching by right foot to the left ear.
>
>>Hi Ed (and Perry)!!
>>
>>You can actually SCAN...ENDSCAN a remote table regardless of back-end source...not that you'd want to.
>>
>>
>>>>
>>>>I'd like to know, would a SCAN...ENDSCAN retrieve data faster than an SQL-SELECT from a remote server???? I'd like to add an OLEBar for download progress into my form, and I was wondering which would be the better to use.
>>>>
>>>>I almost forgot, my SELECT has 3 conditions to meet.
>>>>
>>>>TIA
>>>
>>>Probably, you mean VFP database, and not back-end server (because SCAN is applicable to VFP only). If this is a case, then the difference is following: SEEK/SCAN will be faster if you retrieve few records (few may mean even few hundreds). However, the bigger is number of retrieved records, the faster comparable SQL-SELECT will be.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Reply
Map
View

Click here to load this message in the networking platform