General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2003 Server
>>2. Building a single "UPDATE" statement and using macro expansion did NOT, indeed it made things worse.
>
>Did not expect that to be honest
without seeing code guessing that it this stems from "replace" working on currently loaded buffers vs. update having to identify record first in the set
>Do you mean you create the array once per instantiated object and reuse it rather than using amembers() for each save ?
>Since you have to access all the elements of the array, for each is faster
>>I have not yet gone over to separate cloned objects and using CompObj() but I am looking into it.
What is the reason to check each field via rel. slow vfp code ? if compobj shows difference, gather from name walks the object fields in C, should be faster. Having special data objects with no other properties probably speeds this process up a tiny bit.
If this is an attempt to minimize conflict frequency, using other approaches is preferable IMHO.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only