Tag: performance

Testing is Hard and we often use the wrong Incentives

Reading Time: 14 min, Date: 2024-06-30

I have been spending a lot of time thinking about testing and reviewing testing lately. At a superficial level - testing looks simple: Write test matrix, code tests, run tests, learn we...

Why are Databases so Hard to Make? Part 2 - Logging to Disk

Reading Time: 8 min, Date: 2024-06-23

Transaction logs. Why are they so important and why are they so hard to make?

Why are Databases so Hard to Make? Part 1 - CPU usage

Reading Time: 12 min, Date: 2024-06-09

In our previous blogs, we have visited the idea that "databases are just loops". At this point, my dear readers may rightfully ask: "if those database are indeed just -...

Databases are Just Loops - Part 3: Row and Batch execution

Reading Time: 8 min, Date: 2024-05-30

Our database journey makes a brief stop. We need to appreciate an important design decision every database must make: Should I use row or batch execution? Depending on the database - or...

Databases are just Loops - Part 2: GROUP BY

Reading Time: 4 min, Date: 2024-05-28

In my previous post - I introduced the idea that you can think of database queries as a series of loops. Let me take this ideas even further - introducing more complex database concepts in...