+ Start a Discussion

Upsert problem .....

Hai, I post again twice today with different topic.. Here is the scheme :
There is object with external Id, let's say 'AId'. The problem is when calling upsert, if there is AId -> it will update (it's okay), but if there isn't AId value that match, it will not create new record instead it will send email. I know upsert method can't do this alone. My thought is using query + update, but the real problem is there are so many records if I want to query. the records are approximately 100.000 records per day that want to be processed. Are there any other methods that more efficient to solve my problem. Any assists would be appreciated.