Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG: INSERT INTO not support ALIAS()
Message
From
08/08/2003 10:01:01
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00818098
Message ID:
00818207
Views:
15
>Can you prove that it's faster? It is certenly isn't cleaner.

yes. within a INSERT the difference is minimal, but difference exist.

VFP eval "(ALIAS())" with 10% extra time respect to "ALIAS()"
CREATE CURSOR my (x L)
t1=SECONDS()
FOR i=1 TO 3000000
NEXT
t2=SECONDS()-t1
t1=SECONDS()
FOR i=1 TO 3000000
 =ALIAS()
NEXT
? SECONDS()-t1-t2
t1=SECONDS()
FOR i=1 TO 3000000
 =(ALIAS())
NEXT
? SECONDS()-t1-t2
t1=SECONDS()
FOR i=1 TO 3000000
 =((((((((((((((((((((((ALIAS()))))))))))))))))))))))
NEXT
? SECONDS()-t1-t2
whichever character in a VFP variable expression demands time to runtime.
VFP have a expression optimizer only for constant expression.
t1=SECONDS()
FOR i=1 TO 3000000
NEXT
t2=SECONDS()-t1
t1=SECONDS()
FOR i=1 TO 3000000
 =4
NEXT
? SECONDS()-t1-t2
t1=SECONDS()
FOR i=1 TO 3000000
 =(4)
NEXT
? SECONDS()-t1-t2
t1=SECONDS()
FOR i=1 TO 3000000
 =((((((((((((((((((((((4))))))))))))))))))))))
NEXT
? SECONDS()-t1-t2
>From VFP help:
>"INSERT INTO dbf_name
>Specifies the name of the table to which the new record is appended. dbf_name can include a path and can be a name expression".

With this logic, UPDATE,SELECT AND DELETE don't support name expression.

VFP Help is a correlate HELP, not a exact HELP.

>I didn't say that. It's your own conclusion.
> I don't see how is it relevant.

Is relevant because nobody know the true VFP specific design ( for me this document don't exist ), and whichever conjecture is possible.

However I hope that also this message comes read from the VFPT, and that they draw their conclusions.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform