4 ms·
I’d take oracle over MS SQL any day. That said I’d take PostgreSQL over oracle any day.
by abirch 1y ago
I’d take oracle over MS SQL any day. That said I’d take PostgreSQL over oracle any day.
- deskamess 1y agoCurious if that is from recent experience? I used Oracle decades ago but these days it's all SQL Server.
- abirch 1y agoYes, 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 1y agoUnder 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.