I have a process that creates a polyline shape one at a time.
For each polyline, depending on associated keys, I need to update the shape on either table A matching on the keys or table B matching on the keys.
ie I have the polyline
if key 1 and key 2 are populated
update the shape on a row on table A matching on key1, key2, plus 2 other keys (key3 and key4)
else
update the shape on a row on table B matching on key3 and key4
The issue is I cannot work out whether it is best to get layers of table A and B up front (many thousand of rows) and somehow filter before updating or should I get these one at a time. Also, what would the actual shape update command be as I have not yet written code to update a shape on an existing SQL server table row?
There may be many polyline shapes to process.
I realise this is vague but any ideas about how I should do this would be appreciated. It needs to be as efficient as possible.
Maybe someone has already done something similar and has code examples.