{"id":1925,"date":"2026-01-19T16:41:51","date_gmt":"2026-01-19T16:41:51","guid":{"rendered":"https:\/\/www.hammerdb.com\/blog\/?p=1925"},"modified":"2026-01-19T16:42:22","modified_gmt":"2026-01-19T16:42:22","slug":"what-is-a-benchmark","status":"publish","type":"post","link":"https:\/\/www.hammerdb.com\/blog\/uncategorized\/what-is-a-benchmark\/","title":{"rendered":"What Is a Benchmark?"},"content":{"rendered":"<p data-start=\"684\" data-end=\"756\">Most people don\u2019t realise that benchmarks pre-date computers by decades.<\/p>\n<p data-start=\"758\" data-end=\"979\">The idea comes from land surveying. Long before software or databases existed, surveyors faced a simple problem: how do you measure something today and be confident you\u2019re measuring the same thing months or years later?<\/p>\n<p data-start=\"981\" data-end=\"1140\">The answer was the <strong data-start=\"1000\" data-end=\"1013\">BENCH MARK<\/strong> \u2014 a fixed reference point, literally set into stone, that could be returned to again and again, knowing it hadn\u2019t moved.<a href=\"https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2026\/01\/C9benchmark.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1926 aligncenter\" src=\"https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2026\/01\/C9benchmark.jpg\" alt=\"\" width=\"340\" height=\"256\" srcset=\"https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2026\/01\/C9benchmark.jpg 340w, https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2026\/01\/C9benchmark-300x226.jpg 300w\" sizes=\"auto, (max-width: 340px) 100vw, 340px\" \/><\/a><\/p>\n<p data-start=\"981\" data-end=\"1140\">That original idea still matters.<\/p>\n<hr data-start=\"1177\" data-end=\"1180\" \/>\n<h2 data-start=\"1182\" data-end=\"1223\">The Core of a Benchmark: Repeatability<\/h2>\n<p data-start=\"1225\" data-end=\"1278\">At its heart, a benchmark is about <strong data-start=\"1260\" data-end=\"1277\">repeatability<\/strong>.<\/p>\n<p data-start=\"1280\" data-end=\"1402\">If you can\u2019t repeat a measurement and get a comparable result, you don\u2019t really have a benchmark \u2014 you just have a number.<\/p>\n<p data-start=\"1404\" data-end=\"1467\">That\u2019s as true for database benchmarks as it was for surveying:<\/p>\n<ul data-start=\"1469\" data-end=\"1585\">\n<li data-start=\"1469\" data-end=\"1490\">\n<p data-start=\"1471\" data-end=\"1490\">the same workload<\/p>\n<\/li>\n<li data-start=\"1491\" data-end=\"1510\">\n<p data-start=\"1493\" data-end=\"1510\">the same schema<\/p>\n<\/li>\n<li data-start=\"1511\" data-end=\"1534\">\n<p data-start=\"1513\" data-end=\"1534\">the same scalability<\/p>\n<\/li>\n<li data-start=\"1535\" data-end=\"1553\">\n<p data-start=\"1537\" data-end=\"1553\">the same rules<\/p>\n<\/li>\n<li data-start=\"1554\" data-end=\"1585\">\n<p data-start=\"1556\" data-end=\"1585\">the same measurement method<\/p>\n<\/li>\n<\/ul>\n<p data-start=\"1587\" data-end=\"1642\">Change those, and you\u2019ve changed what\u2019s being measured.<\/p>\n<p data-start=\"1644\" data-end=\"1746\">Experimentation isn\u2019t the problem \u2014 it\u2019s the point. A good benchmark makes experimentation meaningful.<\/p>\n<p data-start=\"1748\" data-end=\"1975\">When the benchmark is repeatable, changing a single variable \u2014 hardware, configuration, software version, or scale \u2014 means any difference you observe can reasonably be attributed to that change. Cause and effect become visible.<\/p>\n<p data-start=\"1977\" data-end=\"2020\">But without a stable reference point, you\u2019re guessing.<\/p>\n<hr data-start=\"2022\" data-end=\"2025\" \/>\n<h2 data-start=\"2027\" data-end=\"2077\">\u201cFine or Imprisonment for Disturbing This Mark\u201d<\/h2>\n<p data-start=\"2079\" data-end=\"2185\">Many historic survey benchmarks, particularly metal markers, include a warning stamped directly into them:<\/p>\n<blockquote data-start=\"2187\" data-end=\"2241\">\n<p data-start=\"2189\" data-end=\"2241\"><strong data-start=\"2189\" data-end=\"2241\">\u201cFine or imprisonment for disturbing this mark.\u201d<\/strong><\/p>\n<\/blockquote>\n<p data-start=\"2243\" data-end=\"2445\">But the mark itself wasn\u2019t valuable. However, if it could be moved, every future measurement taken from it would be suspect. Accumulated knowledge depended on that reference point remaining exactly where it was. Instead, what was valuable was trust in the measurement.<\/p>\n<hr data-start=\"2496\" data-end=\"2499\" \/>\n<h2 data-start=\"2501\" data-end=\"2546\">\u201cWe Only Benchmark Our Production Systems\u201d<\/h2>\n<p data-start=\"2548\" data-end=\"2605\">The problem is that production is rarely a single system.<\/p>\n<p data-start=\"2607\" data-end=\"2796\">Over time, organisations accumulate many databases, platforms, and teams. People move on, systems evolve, and each measurement captures a moment that can\u2019t easily be compared with the next.<\/p>\n<p data-start=\"2798\" data-end=\"3017\">Each result may be valid on its own, but without a common benchmark none of them relate to each other. You don\u2019t end up with a strategy \u2014 you end up with isolated measurements tied to individual systems and people with different skill-sets, opinions and bias.<\/p>\n<p data-start=\"3019\" data-end=\"3091\">And once that happens, you don\u2019t really have a database strategy at all.<\/p>\n<p data-start=\"3093\" data-end=\"3375\">You end up with a sprawl: different databases, different platforms, different operating systems, some on-prem, some in the cloud. Each measured differently, at a different time. The numbers don\u2019t line up, and there\u2019s no consistent view of performance \u2014 or of what any of it actually costs.<\/p>\n<hr data-start=\"3377\" data-end=\"3380\" \/>\n<h2 data-start=\"3382\" data-end=\"3424\">Why Repeatability Unlocks Understanding<\/h2>\n<p data-start=\"3426\" data-end=\"3564\">Once a benchmark is accurate and repeatable, something important changes: you can start to understand <em data-start=\"3528\" data-end=\"3533\">why<\/em> things behave the way they do.<\/p>\n<p data-start=\"3566\" data-end=\"3574\">You can:<\/p>\n<ul data-start=\"3576\" data-end=\"3770\">\n<li data-start=\"3576\" data-end=\"3608\">\n<p data-start=\"3578\" data-end=\"3608\">compare hardware generations<\/p>\n<\/li>\n<li data-start=\"3609\" data-end=\"3643\">\n<p data-start=\"3611\" data-end=\"3643\">evaluate configuration changes<\/p>\n<\/li>\n<li data-start=\"3644\" data-end=\"3676\">\n<p data-start=\"3646\" data-end=\"3676\">understand scaling behaviour<\/p>\n<\/li>\n<li data-start=\"3677\" data-end=\"3712\">\n<p data-start=\"3679\" data-end=\"3712\">measure cost versus performance<\/p>\n<\/li>\n<li data-start=\"3713\" data-end=\"3770\">\n<p data-start=\"3715\" data-end=\"3770\">make decisions based on evidence rather than instinct<\/p>\n<\/li>\n<\/ul>\n<p data-start=\"3772\" data-end=\"3963\">The goal isn\u2019t to recreate every detail of production. It\u2019s to create a stable reference point you can return to \u2014 today, next month, or next year \u2014 and trust that the comparison still holds.<\/p>\n<hr data-start=\"3965\" data-end=\"3968\" \/>\n<h2 data-start=\"3970\" data-end=\"3983\">In summary<\/h2>\n<p data-start=\"3985\" data-end=\"4053\">The concept of benchmarks have lasted for centuries because they\u2019re <strong data-start=\"4038\" data-end=\"4052\">repeatable<\/strong>.<\/p>\n<p data-start=\"4055\" data-end=\"4218\">Long before databases or computers, someone looked at the problem of measurement and said: <em data-start=\"4146\" data-end=\"4218\">\u201cIf we want to measure something time and time again, we need a fixed reference point we can trust.\u201d<\/em><\/p>\n<p data-start=\"4220\" data-end=\"4283\">That simple idea is still the foundation of benchmarking today.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Most people don\u2019t realise that benchmarks pre-date computers by decades. The idea comes from land surveying. Long before software or databases existed, surveyors faced a simple problem: how do you measure something today and be confident you\u2019re measuring the same thing months or years later? The answer was the BENCH MARK \u2014 a fixed reference &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.hammerdb.com\/blog\/uncategorized\/what-is-a-benchmark\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;What Is a Benchmark?&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"ppma_author":[5],"class_list":["post-1925","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"authors":[{"term_id":5,"user_id":2,"is_guest":0,"slug":"hammerdb","display_name":"HammerDB","avatar_url":{"url":"https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2018\/10\/logo-white.png","url2x":"https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2018\/10\/logo-white.png"},"author_category":"","user_url":"http:\/\/www.hammerdb.com","last_name":"","first_name":"","job_title":"","description":""}],"_links":{"self":[{"href":"https:\/\/www.hammerdb.com\/blog\/wp-json\/wp\/v2\/posts\/1925","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hammerdb.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hammerdb.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hammerdb.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hammerdb.com\/blog\/wp-json\/wp\/v2\/comments?post=1925"}],"version-history":[{"count":2,"href":"https:\/\/www.hammerdb.com\/blog\/wp-json\/wp\/v2\/posts\/1925\/revisions"}],"predecessor-version":[{"id":1928,"href":"https:\/\/www.hammerdb.com\/blog\/wp-json\/wp\/v2\/posts\/1925\/revisions\/1928"}],"wp:attachment":[{"href":"https:\/\/www.hammerdb.com\/blog\/wp-json\/wp\/v2\/media?parent=1925"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hammerdb.com\/blog\/wp-json\/wp\/v2\/categories?post=1925"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hammerdb.com\/blog\/wp-json\/wp\/v2\/tags?post=1925"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.hammerdb.com\/blog\/wp-json\/wp\/v2\/ppma_author?post=1925"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}