Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Object to Data
Message
From
09/03/2011 04:51:13
 
 
To
08/03/2011 12:29:31
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01502925
Message ID:
01502990
Views:
51
>>(1) amembers and eval() seem fast enough. I do not think that that would be a bottleneck - should it be then you can generate the >>code for each table object
I read somewhere that AMEMBERS is pretty slow.

>>(2) What do you do when two (or more) fields have changed ? One replace statement or more than one ?
I was doing a replace for each, but have now switched to UPDATE, I am testing results.

>> (3) Can you find the bottleneck in the .Save() method ?
Coverage profile does not identify a slow line but it's the AMEMBERS, FOR..ENDFOR

>> (4) update : with/endwith is about 11 % faster
Yes I am already doing that.

Gary.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform