SELECT queries are kinda slow but work.
However, UPDATEs always time out. Even a seemingly simple query runs for ~15 minutes till it fails:
Code: Select all
Update SFDC...Contact
SET TargetX_Email__AltEmail__c = Additional_Email__c
where X18_Dig_RecordID__c = '0036100000tBTAIAA4'
Our Contact object has 150,000+ records. Is this too much for the driver?OLE DB provider "MSDASQL" for linked server "SFDC" returned message "Row cannot be located for updating. Some values may have been changed since it was last read.".
Msg 7343, Level 16, State 4, Line 73
The OLE DB provider "MSDASQL" for linked server "SFDC" could not UPDATE table "[SFDC]...[Contact]". The rowset was using optimistic concurrency and the value of a column has been changed after the containing row was last fetched or resynchronized.
Or is there something wrong with my query?
Is there a document that outlines best practices how to use the driver properly?
Or is there a more performant alternative?
Thanks so much.