Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql statement not being rushmore optimized
Message
From
20/12/2012 22:28:38
 
 
To
20/12/2012 15:15:38
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01560225
Message ID:
01560367
Views:
56
David,

see my reply to Mike.


>Regarding Thomas' reply, the seek/replace code is orders of magnitude faster, so in this case the benefit I would get by using scan instead of do while not eof() wouldn't be significant, I don't think. Also, in other benchmarks I've done, I've found that in loops with replaces, the replace statements contribute to the bulk of the processing time, and the looping construct time is negligible. I find the old style do while not eof() more readable. Correct me if you think I'm off base on this.

If it is more readable to you, stay with Do While Eof(). My preference is in the answer to Mike -
but timing differences probably are not that great.
But - I would still argue to get rid of the "go top" before the seek ;-)

regards

thomas
Previous
Reply
Map
View

Click here to load this message in the networking platform