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

SQL Performance

MAY 16, 2019

Achieving minimal logging using INSERT.SELECT into an empty clustered index target is not quite as simple as described in the Data Performance Loading Guide. The Data Loading Performance Guide contains a high-level summary of the conditions required for minimal logging into clustered tables: This post is concerned with the top row only.

Cache 67

Cache Servers Testing Storage 67

SQL Performance

OCTOBER 20, 2022

This was convenient for the demos but repeatable read isolation isn’t common in everyday use. Rows qualifying for the update must continue to qualify until the change is performed and committed. Using lock classes is better for resource usage, concurrency, and performance than internally escalating to repeatable read would be.

Testing 91

Testing Servers Cache Engineering 91

Dynatrace

SEPTEMBER 17, 2019

Instead of presenting you with a handful of random screenshots from our demo environment I reached out to Robert, a close friend of mine, who leads a development team with the current task to re-architect and re-platform their multi-tenant SaaS-based eCommerce platform. REDIS for caching. NGINX as an API Gateway. 3 Log Analytics.

AWS 128

AWS Monitoring Ecommerce Lambda 128

Brendan Gregg

JULY 2, 2021

cachestat File system cache statistics line charts 7. I chose these to find the most performance wins with the fewest tools. BPF didn't exist on those versions, so I used basic Ftrace capabilities that were available on Linux 3.2. execsnoop New processes (via exec(2)) table 2. opensnoop Files opened table 3. at the time.

Open Source 40

Open Source Latency Cache Energy 40

SQL Performance

JUNE 5, 2019

Some queries need more memory than others to execute, based on what operations need to be performed (e.g. Neither is ideal, and when you simply have too many queries asking for more memory than is available to grant, you’ll see RESOURCE_SEMAPHORE waits. sort, hash). If it underestimates memory, then you can see spills in tempdb.

Servers 41

Servers Cache Database Metrics 41

SQL Performance

OCTOBER 7, 2020

Its raison d’être is to cache result rows from a plan subtree, then replay those rows on subsequent iterations if any correlated loop parameters are unchanged. For more background on these performance spools see my prior article. Spools are the least costly way to cache partial results. Demo 1: Inaccurate Rewinds.

Servers 106

Servers Cache Azure Performance 106

SQL Performance

SEPTEMBER 25, 2019

Performance spools are lazy spools added by the optimizer to reduce the estimated cost of the inner side of nested loops joins. An example plan shape showing a lazy table performance spool is below: The questions I set out to answer in this article are why, how, and when the query optimizer introduces each type of performance spool.

Performance 104

Performance Cache Servers Education 104

Percona

JANUARY 4, 2023

Recently I was working with a customer wherein our focus was to carry out a performance audit of their multiple MySQL database nodes. We started looking into the stats of the performance schema. I realized that it is important to understand the insights of the performance schema and how we can make effective use of it.

Performance 98

Performance C++ Monitoring Servers 98

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

Dynatrace

OCTOBER 7, 2021

AWS AppSync: AppSync offers a fully managed approach to developing APIs with GraphQL — connecting to AWS DynamoLB or Lambda along with adding caches and client-side data. Amazon S3: The Simple Storage Service stores and retrieves data from anywhere with scalability, data availability, security, performance, and a high degree of durability.

Serverless 283

Serverless AWS Lambda Storage 283

Dynatrace

NOVEMBER 3, 2021

Because monitoring tends to focus on key indicators such as utilization rates and throughput, monitoring indicates overall system performance. Examples include a spike in memory utilization, a decrease in cache hit ratio, or an increase in CPU utilization. This centralized, automatic approach eliminates the need for manual diagnostics.

Monitoring 223

Monitoring Metrics DevOps Scalability 223

Percona

MAY 2, 2023

PBM is a fully-supported community backup tool capable of performing cluster-side consistent backups in MongoDB for replica sets and sharded clusters. Hence, the node would still be available for other operations. Logical backups These are the types of backups where data is dumped from the databases into the backup files.

Best Practices 52

Best Practices Database Storage Servers 52

Smashing Magazine

MARCH 7, 2022

In my last article , I suggested using the SaveData API to deliver a different, more performant, experience to users that expressed that desire. That user preference is available in two (hopefully soon to be three!) This is available behind a flag in Chrome, but not yet on by default while it finishes standardization.

Website 103

Website Media Mobile Network 103

Smashing Magazine

AUGUST 31, 2021

You can check a real-world implementation of this ContextAPI pattern in our demo repository. If you have multiple pieces of state defined in a single context, you may start running into performance issues. how to handle when data is not available (server error, or no data). zero-config caching layer. </p> ) }.

Cache 103

Cache Servers Best Practices Code 103

SQL Performance

MAY 29, 2019

For more background, see the Data Performance Loading Guide and the Tiger Team notes on the behaviour changes for SQL Server 2016. The script below is a modification of the demo used in earlier parts in this series. GO. -- Clear the plan cache. The modified demo script is: IF OBJECT_ID ( N'dbo.Test' , N'U' ) IS NOT NULL.

Cache 64

Cache Testing Servers Code 64

Smashing Magazine

FEBRUARY 3, 2022

This is clearly not just bad for the environment — it’s bad for performance and hurts our users too. The performance impact is be measured with PageSpeed Insights. These numbers are based on first-page load — caching seems very efficient for subsequent page loads. Description. JS (uncached). Two embeds. Description.

Social Media 101

Social Media Media Website Airlines 101

SQL Performance

NOVEMBER 22, 2019

While an eager index spool may only appear on the inner side of an nested loops apply , it is not a "performance spool". The total memory grant available for sorting is sufficient, but it is evenly split between parallel threads (as usual). For the difference between the two, please see my article Apply versus Nested Loops Join.

Servers 77

Servers Cache Database Performance 77

Abhishek Tiwari

NOVEMBER 3, 2018

They often get blindsided by vendor’s pitch and end-up making decision based on some fancy demos (see my post from 2014 on Adobe AEM ). I am yet to find a traditional CMS vendor who can deliver this level of performance on the scale (millions of page views per day). Eventually, we decided to move them to Jekyll.

Systems 63

Systems Cache Website Network 63

Dynatrace

JUNE 18, 2019

It only took about 15 minutes to set up this approach with Dynatrace and get detailed insights into Android app performance. Build performance. If you want to include Dynatrace in development and staging builds, build performance is crucial. Moreover, features like Instant Run and the Gradle Build Cache weren’t supported.

Cache 27

Cache Java Monitoring Tuning 27

SQL Performance

MARCH 8, 2021

This can make it difficult to draw sound performance-tuning conclusions. Total elapsed time is 933ms with 6,673ms of CPU time with a warm cache. Both calculations are performed over the per-thread truncated millisecond values. We can do the correct offset calculation manually using the data available in the plan.

Servers 95

Servers Tuning Architecture Processing 95

Smashing Magazine

JANUARY 21, 2019

Hence, the API can be implemented on any language (which is one of the beauties of GraphQL: being a specification and not an actual implementation has enabled it to become available in a myriad of languages.). Native Client-Side Cache/Data Store. API response example. Recommended reading : Understanding And Using REST APIs.

Social Media 64

Social Media Database Media Website 64

Smashing Magazine

JANUARY 11, 2021

Front-End Performance Checklist 2021. Front-End Performance Checklist 2021. This guide has been kindly supported by our friends at LogRocket , a service that combines frontend performance monitoring , session replay, and product analytics to help you build better customer experiences. Web performance is a tricky beast, isn’t it?

Performance 145

Performance Cache Media Metrics 145

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

Smashing Magazine

APRIL 29, 2021

While not render-blocking, they can indirectly impact render performance. If using 11ty for your static sites, try the 11ty high-performance blog template. It also shows up on hover in the DevTools Performance panel. They found that 2x was a sweet spot of both good performance wins with no degradation in quality metrics.

Media 145

Media Network Metrics Mobile 145

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