>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.
The SQL WHERE clause will include all the modified fields. Adding an index for each of them will speed things up.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer