Percona

APRIL 17, 2023

The main objective of this post is to share my experience over the past years tuning MongoDB and centralize the diverse sources that I crossed in this journey in a unique place. The swap issue is explained in the excellent article by Jeremy Cole at the Swap Insanity and NUMA Architecture. mongodb-sysctl.conf – if /etc/sysctl.d

Best Practices 52

Best Practices Design Tuning Database 52

SQL Performance

APRIL 27, 2020

Hyperscale achieves high performance from each compute node having SSD-based caches which helps minimize the network round trips to fetch data. There is a lot of awesome technology involved with Hyperscale in how it is architected to use SSD-based caches and page servers. Serverless Database. New Azure SQL Database Standard Tier Sizes.

Azure 55

Azure Database Serverless Hardware 55

MachMetrics

JULY 31, 2020

So in this article, we’ll pit Gzip vs Brotli and completely end the debate! 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. One such measure is HTTP compression. OK, not really.

Speed 67

Speed Servers Google Tuning 67

Smashing Magazine

SEPTEMBER 6, 2021

Practical HTTP/3 deployment options ( current article ). You would, however, be hard-pressed even today to find a good article that details the nuanced best practices. However, as discussed in part 2 , push is very difficult to use correctly due to issues with congestion control, caching, prioritization, and buffering.

Network 105

Network Servers Cache Traffic 105

Smashing Magazine

APRIL 11, 2022

However, developers with a deep understanding of the project may want to improve performance beyond that by doing some fine-tuning under the hood. We can use the preload attribute for the HTML link element to optimize loading performance by ensuring that the browser discovers the resource earlier, downloads it, and caches it.

Media 70

Media Tuning Metrics Google 70

SQL Performance

JUNE 21, 2019

This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. I tend to recommend increasing this value to a higher number after examining the Plan Cache. I've been teaching and writing about common SQL Server mistakes for many years.

Servers 49

Servers Azure Hardware Database 49

DZone

AUGUST 16, 2019

In this article, we explain why you should pay attention to when building a scalable application. When you build a great product or application, sooner or later, it will be drawing attention more and more users who will expect a flawless, perfect application as the demand grows in the time it handles more and more requests per minute.

Scalability 145

Scalability Efficiency Hardware Software 145

High Scalability

NOVEMBER 25, 2019

In this article, I will share the current architecture and some of the lessons we learned scaling it along with some of the things we are looking to improve upon in the near future. Edge caching. In general, Egnyte connect architecture shards and caches data at different levels based on: Amount of data. Disk based caching.

Architecture 52

Architecture Cache Azure Storage 52

SQL Server According to Bob

JANUARY 11, 2020

Important When planning, deploying, and maintaining a Microsoft SQL Server installation, ensure that the I/O system supports all the factors outlined in this article. Stable media is commonly physical disk storage, but other devices and certain caching facilities qualify as well.

Servers 40

Servers Cache Media Hardware 40

Percona

JANUARY 17, 2019

In this article, we will look at how this can improve the reporting/analytical query performance in MySQL. 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. The second and third run used the cached data. Test data and versions.

Cache 46

Cache C++ AWS Airlines 46

SQL Performance

MARCH 8, 2021

This can make it difficult to draw sound performance-tuning conclusions. This article aims to help you understand where the timings come from in each case, and how they can be best interpreted in context. See the linked very detailed article if you are interested in all of the finer detail. The scope of cumulative times.

Servers 95

Servers Tuning Architecture Processing 95

Smashing Magazine

AUGUST 22, 2021

HTTP/3 performance features ( current article ). This has led to many articles claiming that QUIC also doesn’t use congestion control, that QUIC can instead start sending data at a much higher rate over UDP (relying on the removal of HOL blocking to deal with packet loss), that this is why QUIC is much faster than TCP.

Performance 106

Performance Network Latency Servers 106

Smashing Magazine

AUGUST 9, 2021

These statements and articles typically skip over some crucial technical details , are lacking in nuance, and usually are only partially correct. In this article series, I will discuss the new protocol, especially its performance features , with more nuance. We will discuss these features in more depth later in this article.

Transportation 145

Transportation Internet Internet Network 145

Speed Curve

DECEMBER 25, 2013

The following article was originally published in the 2013 Performance Calendar. There's 31 great articles to explore in the calendar including Steve Souders's browser wishlist and Tim Kadlec's take on what it takes to create a performance culture. -. All CMS's should be offering this level of image manipulation and caching.

Performance 60

Performance Mobile Website Benchmarking 60

HammerDB

NOVEMBER 5, 2018

Note that the parameters in this article do have the potential to cause data loss if implemented on your production database without full understanding so ensure that you have read this post in its entirety before applying the settings to your environment. . To illustrate the data reads on Oracle we can flush the buffer cache.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

SQL Server According to Bob

JANUARY 11, 2020

Time of Last Access The time of last access is a caching ​​ algorithm ​​ that enables ​​ cache ​​ entries to be ordered by their ​​ access times.

Servers 40

Servers Cache Database Media 40

Smashing Magazine

JUNE 26, 2020

CSS transforms are ideal tools for fine-tuning the size and position of elements within grids’ constraints. NB: Smashing members have access to a beautifully designed PDF of Andy’s Inspired Design Decisions magazine and full code examples from this article. They’re also useful for adding unusual touches to a design. Large preview ).

Design 95

Design Media C++ Energy 95