Alex Russell

MARCH 6, 2021

A then-representative $200USD device had 4-8 slow (in-order, low-cache) cores, ~2GiB of RAM, and relatively slow MLC NAND flash storage. mid-priced Androids were slightly faster than 2014's iPhone 6. Chip design choices and silicon economics are the defining feature of the still-growing Performance Inequality Gap.

Performance 124

Performance Network Cache Metrics 124

SQL Performance

APRIL 8, 2019

The L3 cache size is 64MB. Both of these Intel processors are special bespoke models that are not in the Intel ARK database. The older Intel Xeon E5-26xx v3 (Haswell) series which was introduced in Q3 of 2014, had a maximum memory bandwidth of 2133MHz. The L3 cache size is 64MB. lanes for I/O connectivity.

Azure 42

Azure Virtualization Storage Benchmarking 42

SQL Server According to Bob

JUNE 3, 2016

Internally DBCC CHECK* uses a page scanning coordinator design (MultiObjectScanner.) SQL Server 2016 changes the internal design to (CheckScanner), applying no lock semantics and a design similar to those used with In-Memory Optimized (Hekaton) objects, allowing DBCC operations to scale far better than previous releases.

Hardware 40

Hardware Cache Servers Software Engineering 40

SQL Server According to Bob

JUNE 3, 2016

In the Sep 2014 the SQL Server CSS and Development teams performed a deep dive focused on scalability and performance when running on current and new hardware configurations. “SQL Server 2016 running on the same hardware as SQL Server 2014, 2012, 2008, 2008 R2 or 2005 uses fewer resources and executes a wide range of workloads faster.

Hardware 40

Hardware Software Engineering Transportation Scalability 40

Percona

JUNE 4, 2023

Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). While originally designed to be a drop-in replacement for MySQL, it evolved into its own distinct database management system and is now maintained and supported by the MariaDB Foundation.

Open Source 52

Open Source Servers Storage Scalability 52

Alex Russell

APRIL 29, 2021

Delayed three years ( Chrome 40, November 2014 vs. Safari 11.1, A subset ( element.animate() ) has enabled developers to more easily create high-performance visual effects with lower risk of visual stuttering in Chrome and Firefox since 2014. For example, an area where Apple is absolutely killing it is in mobile CPU design.

Media 145

Media Games Education Engineering 145

SQL Performance

MARCH 8, 2021

SQL Server 2014 SP2 and later produce runtime (“actual”) execution plans that can include elapsed time and CPU usage for each execution plan operator (see KB3170113 and this blog post by Pedro Lopes). The following examples use the public Stack Overflow 2013 database ( download details ), with a single index added: CREATE INDEX PP ON dbo.

Servers 95

Servers Tuning Architecture Processing 95