Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Select VFP vs SQL Server
Message
From
03/10/2014 16:52:18
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
18/09/2014 09:42:10
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01607580
Message ID:
01608760
Views:
73
>While you're at it... long ago, I measured the if against assignment, and the assignment won... But that was back in VFP 5 or 6, so... can you compare this to your other measurements?
>
>
kcString = REPLICATE("a",100)
>a=SECONDS()
>FOR y = 1 TO 100000
>	lcstring = ""
>	lcComma=""
>	for x = 1 to 10
>	  lcString = m.lcString + lcComma+kcString
>	  lcComma=", "
>	endfor
>ENDFOR y
>?"create comma each time",SECONDS()-m.a
>
Here's one Gene Wirchenko from Foxite just sent me...
a=SECONDS()
FOR y = 1 TO 100000
	lcstring = kcString
	for x = 2 to 10
	  lcString = m.lcString + "," + kcString
	endfor
ENDFOR y
?"(Skip adding the last comma and having no if.)",SECONDS()-m.a
That seems completely workable, but my gut tells me it can't work for a do while loop. Can't put my finger on the problem.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform