Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select alltrim(lname) is 10x longer than select lname
Message
From
17/08/2006 11:13:22
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
17/08/2006 10:55:53
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:
01146401
Views:
20
>Sergey, you are absolutely correct - there is now no time difference. Unfortunately, the time is now the longer of the two times. now:
>
>select lname, fname from table1 into cursor cursor1 nofilter
>
>takes about 4 seconds. without the nofilter, the above statement only took 0.4 seconds.
>
>consistency is great but i'm hoping for consistently good! :-)

It's not just the query. Check the time required to populate your combo box with and without NOFILTER.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform