Alex Russell

MARCH 6, 2021

TL;DR: A lot has changed since 2017 when we last estimated a global baseline resource per-page resource budget of 130-170KiB. A then-representative $200USD device had 4-8 slow (in-order, low-cache) cores, ~2GiB of RAM, and relatively slow MLC NAND flash storage. The Moto G4 , for example. Here begins our 2021 adventure. Hard Reset.

Performance 124

Performance Network Cache Metrics 124

MachMetrics

DECEMBER 14, 2019

How fast is the average time to first byte (server delay)? In 2017, mobile internet usage passed desktop as the majority. How long is the average server delay? It is typically reduced via server-side optimizations, such as enabling caching and database indexes. How fast is the average page load time in 2020?

Best Practices 105

Best Practices Speed Mobile Google 105

Percona

JANUARY 17, 2019

I will compare AWS Aurora with MySQL (Percona Server) 5.6 Aurora Parallel Query response time (for queries which can not use indexes) can be 5x-10x better compared to the non-parallel fully cached operations. 84.1 | | version_comment | Percona Server (GPL), Release 84.1, MySQL on ec2.

Cache 47

Cache C++ AWS Airlines 47

SQL Performance

NOVEMBER 4, 2021

First introduced in SQL Server 2017 Enterprise Edition, an adaptive join enables a runtime transition from a batch mode hash join to a row mode correlated nested loops indexed join (apply) at runtime. This is a just a presentation decision—the Concat and joins are still present in the code run by the SQL Server execution engine.

Servers 98

Servers Design Database Code 98

SQL Performance

APRIL 8, 2019

Back on December 5, 2017, Microsoft announced that they were using AMD EPYC 7551 processors in their storage-optimized Lv2-Series virtual machines. These AMD EPYC processors have a number of advantages for SQL Server workloads, as I will explain in this article. The L3 cache size is 64MB. The L3 cache size is 64MB.

Azure 42

Azure Virtualization Storage Benchmarking 42

Smashing Magazine

JANUARY 7, 2019

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? Long FMP usually indicates JavaScript blocking the main thread, but could be related to back-end/server issues as well.

Performance 103

Performance Cache Metrics Network 103

High Scalability

NOVEMBER 30, 2018

8 : successful Mars landings; $250,000 : proposed price for Facebook Graph API; 33 : countries where mobile internet is faster than WiFi; 1000s : Facebook cache poisoning; 8.2 during the 2017-18 academic year, on top of a 3.3% during the 2017-18 academic year, on top of a 3.3% It was replaced by 48 Cassandra servers.

Internet 28

Internet Internet Scalability Blockchain 28

Smashing Magazine

JANUARY 21, 2019

An API is the communication channel for an application to load data from the server. This relationship can be expressed through an associative array (an array of key => property) on the server-side, in which each module states its name as the key attribute and its inner modules under the property modules. Large preview ).

Social Media 64

Social Media Database Media Website 64

Enprowess

JANUARY 12, 2022

So it is convenient for all to use irrespective of internet speed and it works offline using cached data. Twitter Lite PWA : It was integrated as the standard User Interface in 2017. IBM OpenWhisk, Microsoft Azure, AWS Lambda, and Google Cloud Functions are famous names that provide server-less services. AI-powered Chatbots.

Blockchain 59

Blockchain IoT Development Serverless 59

All Things Distributed

OCTOBER 2, 2017

Today marks the 10 year anniversary of Amazon's Dynamo whitepaper , a milestone that made me reflect on how much innovation has occurred in the area of databases over the last decade and a good reminder on why taking a customer obsessed approach to solving hard problems can have lasting impact beyond your original expectations.

Internet 128

Internet Internet AWS Performance 128