Commit

Scanning Ansible code with Ansible Lint

Introduction It’s always good to learn something new. But doing it the right way from the very beginning is even better. I recently started to work with Ansible and after creating a few roles, I quickly realized that there(…)

Oracle Blockchain Tables: COMMIT-Time

Oracle Blockchain Tables are available now with Oracle 19.10. (see Connor’s Blog on it), they are part of all editions and do not need any specific license. I.e. whenever we need to store data in a table, which(…)

AWS Aurora vs. RDS PostgreSQL on frequent commits

This post is the second part of https://www.dbi-services.com/blog/aws-aurora-xactsync-batch-commit/ where I’ve run row-by-row inserts on AWS Aurora with different size of intermediate commit. Without surprise the commit-each-row anti-pattern has a negative effect on performance. And I mentioned(…)

SQL Server 2014: classic commit vs commit with delayed durability & I/Os

When you learn about SQL Server, you will often hear that a commit transaction is a synchronous operation and that you can trust it. In this blog post, I will provide some details about what we mean by synchronous(…)