Smashing Magazine

SEPTEMBER 28, 2022

The resource loading waterfall is a cascade of files downloaded from the network server to the client to load your website from start to finish. Client Side Rendering, Server Side Rendering And Jamstack. To run it, you have to make another API call to the server and retrieve any data you want to load. Active Memory Caching.

Performance 125

Performance Cache Servers Social Media 125

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. With those out of the way, this article is exclusively about Sorts and when they can rewind.

Servers 106

Servers Cache Azure Performance 106

SQL Performance

APRIL 27, 2020

Azure SQL Database is Microsoft's database-as-a-service offering that provides a tremendous amount of flexibility. Microsoft is continually working on improving their products and Azure SQL Database is no different. HyperScale Database. Hyperscale databases are provisioned using vCores. DTU Pricing Tier.

Azure 55

Azure Database Serverless Hardware 55

SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. These topics apply to both SQL Server Reporting Services as well as Power BI Report Server.

Tuning 67

Tuning Servers Database Best Practices 67

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. 4 Socket, TPCC.

Servers 90

Servers Media Cache Storage 90

SQL Performance

OCTOBER 13, 2021

This article is the twelfth part in a series about named table expressions. I also compare them with stored procedures, mainly focusing on differences in terms of default optimization strategy, and plan caching and reuse behavior. In my examples I’ll use a sample database called TSQLV5. What Is an Inline Table-Valued Function?

Cache 144

Cache Strategy C++ Code 144

SQL Performance

DECEMBER 17, 2019

One initial, easy step to moving your SQL Server on-premises workloads to the cloud is using Azure VMs to run your SQL Server workloads in an infrastructure as a service (IaaS) scenario. You will still have to maintain your operating system, SQL Server and databases just like you would in an on-premises scenario.

Azure 72

Azure Virtualization Servers Storage 72

SQL Performance

MARCH 29, 2022

Simple parameterization has a number of quirks in this area, which can result in more parameterized plans being cached than expected, or finding different results compared with the unparameterized version. When SQL Server applies simple parameterization to an ad-hoc statement, it makes a guess about the data type of the replacement parameter.

Cache 90

Cache Servers Database Testing 90

SQL Server According to Bob

DECEMBER 18, 2018

I was asked to validate the SQL Server behavior in light of the error condition involving fsync/fdatasync outlined in this article. This means data can be stored in file system cache, non-stable media. ) The issue, as described in the link, is that the sync returns the error but may clear the state of the cached pages.

Servers 40

Servers Media Cache Software Engineering 40

Percona

AUGUST 31, 2018

It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. It is important to pay attention to performance when writing database queries. PostgreSQL’s Tuneable Parameters. shared_buffer.

Tuning 57

Tuning Database Performance Benchmarking 57

SQL Performance

JUNE 21, 2019

I've been teaching and writing about common SQL Server mistakes for many years. 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. SQL Server Agent alerts. Database corruption happens unfortunately.

Servers 49

Servers Azure Hardware Database 49

Highly Scalable

SEPTEMBER 18, 2012

These developments gradually highlight a system of relevant database building blocks with proven practical efficiency. In this article I’m trying to provide more or less systematic description of techniques related to distributed operations in NoSQL databases. Data Placement. System Coordination. Read/Write latency.

Database 213

Database Latency C++ Scalability 213

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. Then follow the instructions to either download the BOL or browse online.

Servers 40

Servers Cache Media Hardware 40

Smashing Magazine

MAY 25, 2022

WeakMap can be used in two areas of web development: caching and additional data storage. The result from a function can be cached so that whenever the function is called, the cached result can be reused. With WeakMap() , the cached result will be automatically removed from memory as soon as the object is garbage-collected.

Cache 116

Cache Programming Storage Code 116

Smashing Magazine

AUGUST 3, 2023

Time To First Byte (TTFB) This is the time it takes for the first piece of information from the server to reach the user’s browser. You need to beware that slow server response times can significantly increase TTFB, often due to server overload, network issues, or un-optimized logic on the server side.

Performance 74

Performance Cache Traffic Metrics 74

SQL Server According to Bob

JANUARY 11, 2020

Microsoft, ​​ Windows, ​​ Windows NT, ​​ and Windows Server ​​ are registered trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers 40

Servers Cache Database Media 40

Percona

NOVEMBER 1, 2023

Following the series of blogs written with the intention to describe basic operations matching Docker and open source databases, in this article, I will demonstrate how to proceed with installing MongoDB with Docker. I wrote this article based on the Docker-maintained repository. What are MongoDB Docker Containers?

Scalability 60

Scalability Best Practices Servers Database 60

Smashing Magazine

OCTOBER 2, 2023

In this second article, I’ll go over some key technical highlights from the project. In the first article, I briefly discussed the technical stack that includes a React-based front-end framework, Next.js for the web app, Sanity CMS, Firebase Auth, and Firestore database. With Brad Frost, Stéph Walter and so many others.

Cache 72

Cache Strategy Best Practices Design 72

SQL Performance

NOVEMBER 10, 2021

Last month I explained when SQL Server inlines iTVFs, it applies parameter embedding optimization by default. Parameter embedding means SQL Server replaces parameter references in the query with the literal constant values from the current execution, and then the code with the constants gets optimized. Constant Folding.

Cache 121

Cache Servers Code Database 121

Percona

JULY 17, 2023

MongoDB Community Edition software might set the stage for achieving your high-volume database goals, but you quickly learn that its features fall short of your enterprise needs. First, some stage-setting for this blog article. The popularity of MongoDB MongoDB has emerged as a popular database platform. It ranks No.

Open Source 77

Open Source Database Scalability Software 77

Percona

MAY 15, 2023

The main reason behind this is that MySQL is a relational database system (RDBMS), and any data that is going to be written in it must respect the RDBMS rules. In shard-nothing, each shard can live in a totally separate logical schema instance / physical database server/data center/continent. The POC Why this POC?

Traffic 125

Traffic Scalability Database Servers 125

Smashing Magazine

DECEMBER 23, 2020

The service workers enable the offline usage of the PWA by fetching cached data or informing the user about the absence of an Internet connection. The service workers also retrieve the latest data once the server connection is restored. When developing a PWA, you can cache the application shell’s resources and assets in the browser.

Cache 123

Cache Internet Internet Google 123

Percona Community

DECEMBER 4, 2020

Overview In this article, I look at how poorly designed sharding systems and replication systems in PostgreSQL affect query performance in high volume situations, and how to ensure data consistency across many servers. These are key problems I have encountered as a database consultant, and how I’ve overcome them.

Performance 52

Performance Cache Traffic Database 52

Smashing Magazine

JUNE 25, 2020

Today, we’ll address storing and serving files for both single-server and scalable deployments while considering factors like compression, caching, and availability. Part 3 : Models, Admin, And Harnessing The Relational Database. The two types of Django deployments are: Single-Server. Part 2 : Templating Saves Lines.

Media 69

Media Cache Storage AWS 69

Percona

APRIL 17, 2023

Note that the intent of tuning the settings is not exclusively about improving performance but also enhancing the high availability and resilience of the MongoDB database. The Linux default is usually 60 , which is not ideal for database usage. Spoiler alert: This post focuses on MongoDB 3.6.X

Best Practices 52

Best Practices Design Tuning Database 52

SQL Performance

SEPTEMBER 6, 2022

This article isn’t about the act of lock escalation itself, which is already well documented and generally well understood. Let’s look at some examples using a fresh database. USE master ; -- Create a new test database. -- COLLATE clause only to remind people it exists. ALTER DATABASE Escalation SET. GOTO Start.

Database 98

Database Storage Testing Servers 98

Smashing Magazine

JANUARY 6, 2020

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? It used to provide an insight into how quickly the server outputs any data. What does it mean? Large preview ).

Performance 145

Performance Cache Network Metrics 145

Smashing Magazine

OCTOBER 26, 2018

In this article, I’ll share an overview of what it was that we wanted to achieve and what we encountered while trying to implement our goals. It’s an all-in-one system that is equipped with a working admin interface; it manages database connection, and has a bunch of useful APIs exposed that handle user authentication, routing, and more.

Cache 78

Cache Website Speed Database 78

MachMetrics

DECEMBER 14, 2019

Similar to our article Average Page Load Times for 2018 , we’ll go over the averages for metrics and help you determine if your site is faster or slower than average. By analyzing the data from Backlinko.com and their Page Speed Stats article, we’ll look to answer these questions: What size should be a website be?

Best Practices 105

Best Practices Speed Mobile Google 105

Smashing Magazine

JANUARY 7, 2019

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? Long FMP usually indicates JavaScript blocking the main thread, but could be related to back-end/server issues as well.

Performance 103

Performance Cache Metrics Network 103

Smashing Magazine

SEPTEMBER 20, 2021

When your content is delivered by other means, from other servers or platforms, it can put the user experience and commercial relationship you have built up with your users at risk. A natural language translation service presenting a news website article translated from English to Japanese. Search Engine And Web Archive Cached Results.

Website 89

Website Analytics Google Cache 89

SQL Performance

MAY 16, 2019

For the conditions that apply when the target table is a heap, see the previous article in this series. Without this guarantee, SQL Server might add index rows that are not sorted correctly, which would not be good. Having DMLRequestSort set to true is the only acceptable guarantee of insert input ordering for SQL Server.

Cache 67

Cache Servers Testing Storage 67

SQL Performance

NOVEMBER 4, 2021

First introduced in SQL Server 2017 Enterprise Edition, an adaptive join enables a runtime transition from a batch mode hash join to a row mode correlated nested loops indexed join (apply) at runtime. For brevity, I’ll refer to a “correlated nested loops indexed join” as an apply throughout the rest of this article.

Servers 98

Servers Design Database Code 98

Percona

NOVEMBER 6, 2023

Percona Operators allow users to easily manage complex database systems in a Kubernetes environment. With Percona Operators , users can easily deploy, monitor, and manage databases orchestrated by Kubernetes, making it easier and more efficient to run databases at scale. These methods can be applied to any Custom Resources.

Metrics 71

Metrics Monitoring Database Cache 71

Smashing Magazine

MAY 12, 2022

Recently Noam Rosenthal published two articles analyzing the common benefits and capabilities provided by various frameworks , and also their associated costs. I highly recommend checking out these articles. CrUX is a cloud-based database into which Real User Measurements (RUM) are collected from live Chrome browser sessions.

Google 127

Google Performance Website Mobile 127

SQL Performance

APRIL 8, 2019

These AMD EPYC processors have a number of advantages for SQL Server workloads, as I will explain in this article. This 14nm first-generation AMD EPYC 7551 processor has 32 cores and 64 threads, and it works in one or two-socket servers. The L3 cache size is 64MB. The L3 cache size is 64MB. AMD EPYC 7551 Details.

Azure 42

Azure Virtualization Storage Benchmarking 42

Enprowess

SEPTEMBER 7, 2021

Software Developers got to use JavaScript CLI tools to create the back-end part of web applications or server-side. allows creating web application’s server-side or back-end components. If you wish to find out which one to choose for your next project, read this article. Back-ends and servers. Both Node.js and React.js

Open Source 52

Open Source Virtualization Programming Servers 52