SQL Performance

SEPTEMBER 17, 2019

In the early days of SSRS, a requirement was to also install and configure Internet Information Services (IIS). Best practice for DBAs is really to just treat ReportServer and ReportServerTempDB like any other user database. Disk latency for ReportServer and ReportServerTempDB are very important.

Tuning 67

Tuning Servers Database Best Practices 67

Smashing Magazine

MAY 20, 2020

This metric is important, but quite vague because it can include anything — starting from server rendering time and ending up with latency problems. For example, for an internet shop, it may be a page with a product list, product details page, shopping cart, checkout, and so on. title, value: report.categories['best-practices'].score,

Performance 98

Performance Metrics Best Practices Code 98

CSS - Tricks

MARCH 16, 2020

Google Lighthouse is one of the best-automated tools available on a web developer's utility belt. These are: Performance Accessibility Best Practices SEO Progressive Web App. Because we’ll be running this using Node.js, we’re able to safely use ES6 syntax as we don’t have to worry about those pesky Internet Explorer users.

Google 82

Google Latency Website Metrics 82

Percona

MAY 15, 2023

Best practices indicate that having ProxySQL closer to the application will be more efficient, especially if we decide to activate the caching feature. Let’s see the write operations with 24 and 64 threads: We get a gain of ~33% just using sharding, while for latency, we do not have a cost.

Traffic 121

Traffic Scalability Database Servers 121

Smashing Magazine

JANUARY 7, 2019

Estimated Input Latency tells us if we are hitting that threshold, and ideally, it should be below 50ms. For high-pressure points like animation, it’s best to do nothing else where you can and the absolute minimum where you can't. From Fast By Default: Modern loading best practices by Addy Osmani (Slide 19).

Performance 103

Performance Cache Metrics Network 103

Smashing Magazine

JANUARY 6, 2020

Estimated Input Latency tells us if we are hitting that threshold, and ideally, it should be below 50ms. For high-pressure points like animation, it’s best to do nothing else where you can and the absolute minimum where you can't. From Fast By Default: Modern loading best practices by Addy Osmani (Slide 19).

Performance 145

Performance Cache Network Metrics 145

Smashing Magazine

JANUARY 11, 2021

Estimated Input Latency tells us if we are hitting that threshold, and ideally, it should be below 50ms. For high-pressure points like animation, it’s best to do nothing else where you can and the absolute minimum where you can't. From Fast By Default: Modern loading best practices by Addy Osmani (Slide 19).

Performance 145

Performance Cache Media Metrics 145

Smashing Magazine

AUGUST 22, 2021

This is because HTTP/3 and QUIC mainly help deal with the somewhat uncommon yet potentially high-impact problems that can arise on today’s Internet. Because we are dealing with network protocols here, we will mainly look at network aspects, of which two are most important: latency and bandwidth. Congestion Control.

Performance 105

Performance Network Latency Servers 105

All Things Distributed

JUNE 21, 2017

Based on this experience and learning, we built DynamoDB to be a fast, highly scalable NoSQL database to meet the needs of Internet-scale applications. These high-throughput, low-latency requirements need caching, not as a consideration, but as a best practice. DynamoDB was the first service at AWS to use SSD storage.

Speed 123

Speed Cache Latency AWS 123

Smashing Magazine

AUGUST 9, 2021

You’ve probably heard things like: “HTTP/3 is much faster than HTTP/2 when there is packet loss”, or “HTTP/3 connections have less latency and take less time to set up”, and probably “HTTP/3 can send data more quickly and can send more resources in parallel”. However, it is extremely challenging to actually deploy them at Internet scale.

Transportation 145

Transportation Internet Internet Network 145