Performance

I recently compared MariaDB, MySQL, and PostgreSQL using the real mpazari.com application. The goal was not to produce a synthetic database benchmark. I wanted to answer a more practical question: does MariaDB really have an advantage when an application sends many simple queries? This question came up after reading an argument that PostgreSQL is obviously faster than MySQL, but that MariaDB should be faster for applications with many simple queries, while PostgreSQL is probably better for complex joins. The suggestion was that a MariaDB versus PostgreSQL comparison would be more interesting than a PostgreSQL versus MySQL comparison. ...

In 2004, I was a new math graduate(Junior Dev) working on an in‑house CRM that was evolving into an ERP. It was a Windows Forms application built with VB.NET and SQL Server (think .NET Framework 1.0/1.1 days - Or we were using that version). One day, a form field became painfully slow. The screen generated a mandate_id that could later become an order_id. The ID was created automatically in the database-an auto-increment primary key plus a few validation checks. Unfortunately, pulling that ID started taking 2–3 minutes. Sales and marketing teams were often on the phone with customers, waiting for the number before they could continue. It was a terrible experience. ...