Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
REPLACE Statement Efficiency
Message
From
23/06/2000 22:29:36
 
 
To
23/06/2000 18:27:35
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00384060
Message ID:
00384176
Views:
38
>I know that if I used the second syntax with a REPLACE ALL VFP would take three trips through the database, but I'm curious as to whether internally VFP effectively converts the first form to three separate REPLACEs. The record is afterall in memory. The REPLACE statement should not actually generate any I/O until you move off the record right?
>
> ...kt

No. Internally you'll get three lines. The first one will always be faster.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform