Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement