3 ms·
Oracle is a giant mess, is the sense I got from trying to work with it in the past. While I am loathe to recommend any Microsoft product, SQL Server is at leas
by pmarreck 3y ago
Oracle is a giant mess, is the sense I got from trying to work with it in the past.
While I am loathe to recommend any Microsoft product, SQL Server is at least coherent, and has actual transactions like Oracle (and not just "checkpoints")
- paulryanrogers 3y agoAren't MSSQL and Oracle just doing redo logs, like MySQL? What do you consider not actual transactions? Postgresql keeps dead tuples in place until vacuumed, which seems optimized for rollbacks. But isn't so bad if you're inserting much more than deleting or updating.
- pmarreck 3y agoNestable transactions = “real transactions” to me, I guess. I almost don’t see the point in non-nestable transactions
- paulryanrogers 3y agoSQL standardizes SAVEPOINT for such nesting. Is that not sufficient? FWIW Postgres supports it.