Yes, it's the isolation levels. I want row level locking. I want to have 1 inser... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

		abirch 6 days ago \| parent \| context \| favorite \| on: Oracle engineers caused five days software outage ... Yes, it's the isolation levels. I want row level locking. I want to have 1 insert and 20 selects running at the same time without getting a lock.

branko_d 6 days ago [–]

Under SQL Server’s SNAPSHOT transaction isolation level, writers don’t block readers. We use it in production with good results.

While the internal implementation details differ from Oracle, the end result seems quite similar in practice.

Join us for AI Startup School this June 16-17 in San Francisco!
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact