2 ms·
You are correct, and the solutions I have read are based around locking the index entry when doing an upsert. The question is how it is best done. Simplified ex
by jeltz 13y ago
You are correct, and the solutions I have read are based around locking the index entry when doing an upsert. The question is how it is best done. Simplified explanations: one solution is to insert a row and lock the new row, another solution is to lock the index entry itself.
- pedrocr 13y agoThanks for the answer. I'm sure there's plenty of complexity I'm missing here. It just seems like having an ID-indexed set of mutexes shouldn't be too hard. Does anyone have a good link discussing the design tradeoffs for a performant upsert?