General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>I have been making an attempt to use local views. I have noticed however that when I do that the process seems slower when sending updates back to the table than using the tables directly. I am using send SQL updates, key and modified fields and update using sql update. I have an index built on the key field. Is there anything else I need to be doing that would make the process faster. I am just selecting one record from the table and then sending any changes back.
Using 'Key and Modified' fields is the bottle next. See, for every field you modify VFP adds it to the where of the query creting a kludgy SELECT that is not optimized for some reason, even though the key field is there, VFP is not smart enough to find the record with the PK, then compare all the other fields.
Change you where type to 'Key Field Only' and it will run like a Fox.
Or course, now you have to do your own conflict resolution, but it is worth it.
BOb
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