Re:SQLite Query Language: upsert
by kodablah on Thursday May 10, 2018 @05:36PM
(#17043181)
> You could run a check but it would probably cost as much as the update, which does nothing when a record is not found.
True if the generation of the insert doesn't have some heavier burdens on the caller side. Otherwise, start a txn, do the first, check if 0 updated, then do the second.
True if the generation of the insert doesn't have some heavier burdens on the caller side. Otherwise, start a txn, do the first, check if 0 updated, then do the second.