Behrad Babaee
Leveraging Moore’s Law: Optimising Database Performance
#1about 4 minutes
The evolution of Moore's Law and its impact on software
Moore's Law drove CPU speed increases until 2005, after which the industry shifted focus from single-core performance to multi-core scalability.
#2about 2 minutes
Comparing server hardware from 2006 to 2024
Modern servers have vastly more RAM and significantly faster storage compared to 2006, fundamentally changing the ratio of memory to disk.
#3about 7 minutes
Traditional database architecture and its reliance on caching
Databases designed for limited RAM now use the extra memory in modern hardware as a cache, which sits on top of the original disk-based architecture.
#4about 6 minutes
The problems and unpredictability of database caching
Caching leads to inconsistent performance across environments and fails to improve overall application latency when multiple parallel queries are involved.
#5about 4 minutes
An alternative architecture with the index in RAM
A modern database design can leverage abundant RAM to hold the entire index in memory, enabling direct, fast access to data on SSDs without a cache.
#6about 4 minutes
Achieving speed and efficiency without caching
By using fewer resources like CPU cycles and disk I/O, an index-in-RAM architecture provides consistently fast performance and reduces infrastructure costs.
Related jobs
Jobs that call for the skills explored in this talk.
Team Lead and Senior Software Engineer with focus on AI
Dynatrace
Linz, Austria
Senior
Java
Team Leadership
Backend Engineer - SAP Commerce Cloud (f/m/x)
Douglas GmbH
Düsseldorf, Germany
Intermediate
Senior
Java
Google Cloud Platform
Matching moments
13:18 MIN
How an in-memory caching layer enables massive scale
Single Server, Global Reach: Running a Worldwide Marketplace on Bare Metal in a Cloud-Dominated World
00:57 MIN
The database is the real bottleneck in scaling applications
Scaling Databases
34:37 MIN
Optimizing NoSQL data models for extreme speed
Leveraging Real time data in FSIs
07:52 MIN
The architectural advantage of a SQL-native design
Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases
34:43 MIN
Answering questions on Cube's architecture and use cases
Making Data Warehouses fast. A developer's story.
04:52 MIN
The critical need for performance in modern applications
In-Memory Computing - The Big Picture
20:28 MIN
The architecture and limitations of in-memory databases
In-Memory Computing - The Big Picture
02:29 MIN
Architectural choices for reducing your carbon footprint
An Architect’s guide to reducing the carbon footprint of your applications
Featured Partners
Related Videos
In-Memory Computing - The Big Picture
Markus Kett
Database Magic behind 40 Million operations/s
Jürgen Pilz
Leveraging Real time data in FSIs
Tim Faulkes
Single Server, Global Reach: Running a Worldwide Marketplace on Bare Metal in a Cloud-Dominated World
Jens Happe
How building an industry DBMS differs from building a research one
Markus Dreseler
Scaling Databases
Tobias Petry
Scaling: from 0 to 20 million users
Josip Stuhli
Things I learned while writing high-performance JavaScript applications
Michele Riva
Related Articles
View all articles


.gif?w=240&auto=compress,format)
From learning to earning
Jobs that call for the skills explored in this talk.


Database Reliability Engineer - Core Team
Clickhouse
Remote
Senior
C++
Azure
Python
Google Cloud Platform
+2

Database Reliability Engineer - Core Team
Clickhouse
Remote
Senior
C++
Azure
Python
Google Cloud Platform
+2


Senior Memory Design Engineer - DDR/HBM | Barcelona, Spain (Relocation Provided)
Autsorsa | HR & BPO Solutions
Barcelona, Spain
Senior
GIT
Bash
Perl
VHDL
Python
+1

Senior Software Engineer - Database Internals
Localstack
Hoofddorp, Netherlands
Remote
€5K
Senior
API
Java
Azure
+9

Multi-platform DBA
Optimadata B.V.
Naarden, Netherlands
Remote
€3-5K
MariaDB
MongoDB
Microsoft SQL Server
+1


Storage Architect - IBM Storage - GPFS - Ceph - FlashSystems - Object Storage - Backup & Tape
We Are Orbis Group Ltd
Ceph
Openshift