getting upsert result

17 views
Skip to first unread message

Evgeny M.

unread,
Jan 26, 2016, 2:53:45 PM1/26/16
to Sophia database
Is there a way to get result of sp_upsert() immediatelly? 
Not error code, but actual changed value, in atomic operation without transaction?

Dmitry Simonenko

unread,
Jan 26, 2016, 3:10:22 PM1/26/16
to Sophia database
Whole point of the Upsert operation is to avoid disk reads.
In your case, you may try to read the key right after after the operation.

Evgeny M.

unread,
Jan 27, 2016, 1:46:25 AM1/27/16
to Sophia database
Ah, ok. Thought the point of the op is just atomic change without using transactions.

вторник, 26 января 2016 г., 23:10:22 UTC+3 пользователь Dmitry Simonenko написал:
Reply all
Reply to author
Forward
0 new messages