Scalegrid

DECEMBER 19, 2019

When PgBouncer receives a client connection, it first performs authentication on behalf of the PostgreSQL server. Once the authentication succeeds: PgBouncer checks for a cached connection, with the same username+database combination. If a cached connection is found, it returns the connection to the client. Pool definitions.

Cache 246

Cache Architecture Database Servers 246

Percona

SEPTEMBER 1, 2023

MySQL server performance can sometimes be perplexing, and if you’ve ever wondered about the role of triggers in influencing your MySQL server’s memory allocation, this post is for you. Per-Row Execution : For each affected row, the trigger’s code is executed. What is a Trigger in MySQL?

Cache 64

Cache Database Games Healthcare 64

CSS Wizardry

AUGUST 24, 2022

A thing I see developers do time and time again is make performance-facing changes to their sites and apps, but mistakes in how they measure them often lead to incorrect conclusions about the effectiveness of that work. Problems When Measuring Performance. For example, continuing our task to reduce CSS size: performance.

Benchmarking 212

Benchmarking Metrics Cache Network 212

Smashing Magazine

JUNE 2, 2021

Improving The Performance Of An Online Store (Case Study). Improving The Performance Of An Online Store (Case Study). Every front-end developer is chasing the same holy grail of performance: green scores in Google Page Speed. For this article, we will focus on the first three and the performance adjustments for these.

Performance 115

Performance Cache Website Mobile 115

Dynatrace

JULY 16, 2020

It wouldn’t scale and it wouldn’t perform either. Highly parallel and performant for any API call and doesn’t introduce much overhead. ? It would definitely make my life easier! TenantCache: a cache to store tenant information and API token information and semi-permanent data to avoid unnecessary roundtrips. ?

Cache 234

Cache Serverless Efficiency Tuning 234

Dynatrace

OCTOBER 4, 2022

This data lands in its original, raw form without requiring schema definition. The performance of these queries needs to be at a level where they can support ad-hoc analytics use cases. It uses cost-effective and durable object storage to store massive volumes of data without the traditional cost and performance tradeoffs.

Artificial Intelligence 211

Artificial Intelligence Analytics Storage Government 211

Smashing Magazine

JULY 18, 2022

If you think that static rendering is limited to generic, public content that is the same for every user of your website, you should definitely read this article. You are now “Head of Performance” at Repairing Magazine, the most serious competitor to Smashing Magazine. Eric Burel. 2022-07-18T11:00:00+00:00. 2022-07-18T18:32:57+00:00.

Cache 114

Cache Website Energy Servers 114

Smashing Magazine

JUNE 29, 2021

Without build optimizations (incremental builds, caching, we will get to those soon) this will eventually become unmanageable as well — think about going through all images in a website: resizing, deleting, and/or creating new files over and over again. It is not possible to ship code incrementally.

Cache 129

Cache Website Strategy Traffic 129

Smashing Magazine

JANUARY 6, 2020

Front-End Performance Checklist 2020 [PDF, Apple Pages, MS Word]. Front-End Performance Checklist 2020 [PDF, Apple Pages, MS Word]. Web performance is a tricky beast, isn’t it? How do we actually know where we stand in terms of performance, and what our performance bottlenecks exactly are? Vitaly Friedman.

Performance 145

Performance Cache Network Metrics 145

CSS - Tricks

APRIL 1, 2021

Site performance is potentially the most important metric. The better the performance, the better chance that users stay on a page, read content, make purchases, or just about whatever they need to do. The code for the site is available on GitHub for reference. Here’s the thing: performance is more than a one-off task.

Cache 92

Cache Social Media Media Website 92

CSS - Tricks

MARCH 29, 2021

Maybe it’s part of a performance review to identify critical CSS and reduce unused selectors. Generally, code auditing involves analyzing code to find bugs or other irregularities, like possible performance issues. If you like inspecting CSS code manually, there is the Inspect tool. Table of contents.

Code 110

Code Media Cache Energy 110

Percona

NOVEMBER 7, 2023

This book has five major sections on MVCC and Isolation (108 pages), Buffer Cache and WAL (53 pages), Locks (42 pages), Query Execution (154 pages), and the types of indexes (127 pages). The illustrations are clear, and there are many reference pointers to the documentation or source code where needed.

Cache 91

Cache Servers Operating System Database 91

Smashing Magazine

JANUARY 7, 2019

Front-End Performance Checklist 2019 [PDF, Apple Pages, MS Word]. Front-End Performance Checklist 2019 [PDF, Apple Pages, MS Word]. Web performance is a tricky beast, isn’t it? How do we actually know where we stand in terms of performance, and what our performance bottlenecks exactly are? Vitaly Friedman.

Performance 103

Performance Cache Metrics Network 103

Smashing Magazine

NOVEMBER 26, 2021

However, there are a few ways in which you can make a large code-base easy to maintain. In certain cases, the build will fail if there are type mismatches in your code as Next.js checks for type definition during build time. We recommend using code editor type checking during development.”. applications. From the Next.js

Cache 143

Cache Code Testing Design 143

Smashing Magazine

OCTOBER 2, 2023

Definitely read up on the strategy and reasoning behind this stack in the first article if you missed it. I plan on sharing specifically what I learned from performance and accessibility practices as a first-time lead developer of a team , as well as what I wish I had known before we started. Unoptimized, full-size JPEG is around 1.2

Cache 72

Cache Strategy Best Practices Design 72

SQL Performance

MAY 22, 2019

It’s one of the things we look at during a health audit, and Kimberly has a great query from her Plan cache and optimizing for adhoc workloads post that’s part of our toolkit. I’ve copied the query below, and if you’ve never run it against any of your production environments before, definitely find some time to do so. EXEC dbo. [

Cache 54

Cache Performance Hardware Servers 54

SQL Performance

APRIL 13, 2020

His version can be used for the plan cache – the only challenge there is the information is transient, so you may not capture every query that uses a particular index. If possible, I'll also consider execution counts (from Query Store or the plan cache) to not just understand what query uses an index, but how frequently that query executes.

Tuning 137

Tuning Cache Metrics Testing 137

Brendan Gregg

FEBRUARY 9, 2018

The recently revealed [Meltdown and Spectre] bugs are not just extraordinary issues of security, but also performance. The patches that workaround Meltdown introduce the largest kernel performance regressions I've ever seen. Some older kernels have the KAISER patches for Meltdown, and so far the performance overheads look similar.

Performance 75

Performance Benchmarking Cache Tuning 75

Speed Curve

JUNE 18, 2019

At some point you'll be given permission to "focus on performance" and after many more hours, the website will be fast again. What if there was a way that you could prevent performance from degrading in the first place? Some sort of performance gateway that only allows changes to production code if they meet performance requirements?

Performance Testing 49

Performance Testing Testing Performance Cache 49

Smashing Magazine

NOVEMBER 17, 2022

That is why, today, Web Performance is as important and trendy as having an online presence. Table of Contents: What Is Web Performance? What Is Web Performance? Web performance refers to the speed at which a website loads, how fast it’s downloaded, and how an app is displayed on the user’s browser. Conclusion.

Media 105

Media Cache Website Mobile 105

KeyCDN

DECEMBER 8, 2022

Unoptimized content could also be one of the reasons why your WordPress website is not performing as per your expectations. But if you have not optimized your WordPress properly, your WordPress will definitely be slower than your expectations. However, unoptimized WordPress plugins can drastically drag down your website's performance.

Cache 52

Cache Website Speed Website Performance 52

SQL Performance

APRIL 18, 2022

This parallel plan ( with a Sort operator) is definitely parameterized by the server using simple parameterization. As the name suggests, this contains a code describing the type of parameterization used for the statement. It’s important to remember the plan must be cached. Performance Counters. Reliable Methods.

Cache 58

Cache Servers Database Testing 58

MachMetrics

JUNE 30, 2021

Website performance & speed plays a major role in the success of an online business. High-performing fast sites attract and preserve users better than low-performing ones. The screenshot below explains that page load time and lighthouse performance scores are not the same, yet they are really close to each other.

Cache 78

Cache Speed Google Website 78

Percona

MAY 15, 2023

Nothing is impossible; however, the performances will be so impacted that each operation may take seconds instead of milliseconds or a fraction of it unless lifting some of the rules breaks the relational model. In the MySQL open source ecosystem, we have only two consolidated ways to perform sharding — Vitess and ProxySQL.

Traffic 128

Traffic Scalability Database Servers 128

SQL Performance

JANUARY 11, 2021

all_columns ; The prepared statement from the application looked like this (as seen in the plan cache): ( @P0 varchar ( 8000 ) ) SELECT * FROM dbo.TheThings WHERE TypeID = @P0. We'd definitely prefer to change the query, or the indexes, if we could. But, again, we couldn't add the hint to the query directly.

Cache 59

Cache Tuning Database Performance 59

John McCalpin

SEPTEMBER 17, 2018

Processes running on the two Logical Processors share most of the processor resources (particularly caches and execution units). Last year I was trying to diagnose a mild slowdown in a code, and wanted to be able to use the hardware performance counters to divide processor activity into four categories: Neither Logical Processor active.

Hardware 40

Hardware Performance Cache Programming 40

Brendan Gregg

FEBRUARY 8, 2018

The recently revealed [Meltdown and Spectre] bugs are not just extraordinary issues of security, but also performance. The patches that workaround Meltdown introduce the largest kernel performance regressions I've ever seen. Some older kernels have the KAISER patches for Meltdown, and so far the performance overheads look similar.

Performance 40

Performance Benchmarking Cache Tuning 40

Alex Russell

OCTOBER 22, 2017

TL;DR: performance budgets are an essential but under-appreciated part of product success and team health. Nobody is trying to do a poor job, and yet the results of a “completed” PWA project often require weeks or months of painstaking rework to deliver minimally acceptable performance. Partner meetings are illuminating.

Performance 68

Performance Benchmarking Network Mobile 68

Smashing Magazine

JUNE 25, 2020

It’s not just source code for the configuration, models, views, and templates, but also static assets: CSS and JavaScript, images, icons. Today, we’ll address storing and serving files for both single-server and scalable deployments while considering factors like compression, caching, and availability. Definitions. Philip Kiely.

Media 69

Media Cache Storage AWS 69

CSS Wizardry

MAY 19, 2020

With more standardised FOUT/FOIT behaviour from browser vendors, to the newer font-display specification, performance—and therefore the user—seems to have been finally been put front-and-centre. On this site, in which performance is the only name of the game, I forgo web fonts entirely, opting instead to make use of the visitor’s system font.

Google 364

Google Media Latency Metrics 364

KeyCDN

SEPTEMBER 12, 2019

We normally focus solely on the performance aspect, but today we want to dive into additional ways you can optimize images for the web. The file size of your images of course is very important, but SEO and social media also play an important part in helping your website perform and convert better.

Social Media 106

Social Media Media Google Website 106

The Morning Paper

NOVEMBER 17, 2019

The serverless computing abstraction, despite its many advantages, exposes several low-level operational details that make it hard for programmers to write and reason about their code. Serverless functions are stateless , but can opportunistically reuse cached state across invocations to speed up start times. Don’t do that!

Serverless 58

Serverless Lambda Programming Cache 58

Smashing Magazine

JUNE 26, 2019

Developers are already optimizing front end performance with: Fast web hosting. Clean coding practices. What is it they always say about the definition of insanity? Either way, hosting your fonts and icons from a location where they’ll load more quickly can help you optimize your website for performance. Minification.

Website 110

Website Speed Mobile Design 110

ACM Sigarch

JULY 17, 2023

An example protection technique that can provide this capability is an Error Correcting Code (ECC). Therefore, testing alone is unlikely to be the definitive solution to address these new faults. Such techniques tend to entail significant performance/power overheads and can be prohibitively expensive for the broader server market.

Energy 52

Energy Hardware Best Practices Architecture 52

MachMetrics

JULY 31, 2020

But we’ll definitely help you decide which is the best choice for your situation. As we discussed in our article on how to test your page weight , compression is pretty much standard practice in web performance now, so you absolutely want to make sure you’re taking advantage of it. OK, not really. What is HTTP Compression?

Speed 67

Speed Servers Google Tuning 67

Rigor

DECEMBER 19, 2019

Reading time 4 min It’s important for both technical and business teams to understand the different web performance monitoring options that are available as well as their various use cases and the benefits of each. Understanding Web Performance Monitoring Methodologies. AB Test the Performance Impact of Third Parties.

Monitoring 40

Monitoring Benchmarking Website Traffic 40

John McCalpin

NOVEMBER 5, 2016

In recent years the trend has been to increase core-level performance by the use of SIMD vector instructions, and to increase package-level performance by the addition of more and more cores. With 2 FMA units that have 5-cycle latency, the code must implement at least 2*5=10 independent accumulators in order to avoid stalls.

Cache 40

Cache C++ Latency Hardware 40