Percona

DECEMBER 20, 2018

Let’s look at some of the most popular Percona Database Performance Blog posts in 2018. We’ve had nearly 4 million visits to the blog in 2018: thank you! As 2018 moves into 2019, let’s take a quick look back at some of the most popular posts on the blog this year. How to Speed Up Pattern Matching Queries.

Database 40

Database Tuning Performance AWS 40

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. Hardware optimization : You need to ensure that the CPU, memory, and storage components meet the performance requirements of the database workload. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload.

Tuning 52

Tuning Efficiency Database Performance 52

HammerDB

OCTOBER 12, 2018

As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level. InnoDB is the storage engine that will deliver the best OLTP throughput and should be chosen for this test. . HammerDB difference from Sysbench. c_ytd_payment: 10.00 7 rows in set (0.00 7 rows in set (0.00

Best Practices 40

Best Practices Scalability Performance C++ 40

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. India became a 4G-centric market sometime in 2018. Recall that single-core performance most directly translates into speed on the web. The Moto G4 , for example. Tap for a larger version.

Performance 124

Performance Network Cache Metrics 124

Alex Russell

OCTOBER 22, 2017

Budgets are scaled to a benchmark network & device. JavaScript is the single most expensive part of any page in ways that are a function of both network capacity and device speed. Deciding what benchmark to use for a performance budget is crucial. Performance budgets are set early in the life of the project.

Performance 68

Performance Benchmarking Network Mobile 68

Smashing Magazine

JANUARY 11, 2021

You need a business stakeholder buy-in, and to get it, you need to establish a case study, or a proof of concept using the Performance API on how speed benefits metrics and Key Performance Indicators ( KPIs ) they care about. Note : If you use Page Speed Insights or Page Speed Insights API (no, it isn’t deprecated!),

Performance 145

Performance Cache Media Metrics 145

Smashing Magazine

JANUARY 6, 2020

You need a business stakeholder buy-in, and to get it, you need to establish a case study, or a proof of concept using the Performance API on how speed benefits metrics and Key Performance Indicators ( KPIs ) they care about. Start Render time, Speed Index ). Treo Sites provides competitive analysis based on real-world data.

Performance 145

Performance Cache Network Metrics 145