Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select alltrim(lname) is 10x longer than select lname
Message
 
 
To
17/08/2006 12:33:55
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Network:
SAMBA Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01146381
Message ID:
01146465
Views:
13
>thanks sergey. i understand a bit more now about what you and mike are saying. i didn't understand at first (you can see my last post to mike as proof of that) :-)
>
>"nofilter" means the data is being taken from the server to the client. without nofilter, the data is not coming from the server to the client - it is still on the server but filtered.
>
>Is that what you're saying?
>
>if so, i now understand s why you wanted to compare "apples to apples" so to speak by using "nofilter" on both.
>
>this maybe a stupid question, but can i keep everything on the server and only view and make changes from a client, or is it everytime i need to make changes to a table i will run into the same network bottleneck?

Hi Paul,

All the processing in VFP is always done on workstation regardless where data is located. W/o NOFILTER VFP may do (if it can) something like
*** select lname from table1 into cursor cursor1
SELECT 0
USE table1 AGAIN ALIAS cursor1
SET FIELDS TO lname 
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform