Smashing Magazine

DECEMBER 23, 2020

You’ll also find example code or references to more specific guides so you can implement these tips to your PWA. 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. Cached content with IndexedDB. Skeleton screen examples on Code My UI.

Cache 123

Cache Internet Internet Google 123

SQL Performance

NOVEMBER 10, 2021

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. In my examples, I’ll use a sample database called TSQLV5. This process enables simplifications that can result in more optimal query plans.

Cache 121

Cache Servers Code Database 121

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. Normally this solution requires a full code redesign and could be quite difficult to achieve when it is injected after the initial code architecture definition.

Traffic 125

Traffic Scalability Database Servers 125

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

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. Philip Kiely. Definitions.

Media 69

Media Cache Storage AWS 69

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

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

SEPTEMBER 20, 2021

They all generally are instrumented as JavaScript processes that are loaded onto your site’s web pages through a tag or snippet of loader code. A natural language translation service presenting a news website article translated from English to Japanese. Search Engine And Web Archive Cached Results. Large preview ).

Website 89

Website Analytics Google Cache 89

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’s much easier to reach performance goals when the code base is fresh or is just being refactored.

Performance 145

Performance Cache Network Metrics 145

Smashing Magazine

AUGUST 3, 2023

HTML Processing Once a web page’s HTML file has been downloaded, the browser begins to process the contents line by line, translating code into the visual website that users interact with. It also opens up the possibility for more effective use of caching strategies, potentially enhancing load times further.

Performance 74

Performance Cache Traffic Metrics 74

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. Metrics can be captured without writing any code.

Metrics 71

Metrics Monitoring Database Cache 71

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

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? How do we actually know where we stand in terms of performance, and what our performance bottlenecks exactly are?

Performance 103

Performance Cache Metrics Network 103

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. Because of its history and for being sort of a fork of an old blogging platform called “b2” (more details here ), it’s largely written in a procedural way (using function-based code).

Cache 78

Cache Website Speed Database 78

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. In each of the deployment models, the role of the database administrator is to make sure that SSRS is stable, dependable, and recoverable.

Tuning 67

Tuning Servers Database Best Practices 67

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 Server According to Bob

DECEMBER 18, 2018

Durability: “In database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently. Microsoft SQL Server Database Engine Input/Output Requirements. Device level flushing may have an impact on your I/O caching, read ahead or other behaviors of the storage system.

Servers 90

Servers Media Cache Storage 90

Particular Software

MAY 8, 2023

When code breaks, our first move is carefully inspecting the call stack. For example, in a highly observable system, we can easily infer the internal state and behavior of the system without going back into the code to make changes when something unexpected occurs. All of these components can participate in a business transaction.

Systems 52

Systems C++ Azure Metrics 52

SQL Performance

FEBRUARY 16, 2021

This stored procedure, which I created in the AdventureWorks2017 database, has two parameters: @CustomerID and @SortOrder. The following is the code to execute the stored procedure: EXECUTE Sales. Sometimes Plan Caching Isn't Such a Good Idea. Below is the code: EXECUTE Sales. The reason, in this case, is plan caching.

Cache 54

Cache Efficiency Code Performance 54

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. This cache is often supported by a battery-powered backup facility.

Servers 40

Servers Cache Media Hardware 40

SQL Performance

NOVEMBER 4, 2021

For brevity, I’ll refer to a “correlated nested loops indexed join” as an apply throughout the rest of this article. If you need a refresher on the difference between nested loops and apply, please see my previous article. You can find more details about this in the Appendix and Related Reading sections of this article.

Servers 98

Servers Design Database Code 98

Jos

JUNE 2, 2018

There was something gratifying in taking a code that takes minutes to run and make it run in a handful seconds. Normally the team decides how well to cover and test the code, and it’s important that all developers in a team know how to write tests. That way you won’t merge nor deploy code that decreases the performance.

Performance 237

Performance Speed Google Media 237

Smashing Magazine

JANUARY 21, 2019

This article was updated on January 31, 2019 to react to readers’ feedback. We will explore these in details throughout the article, but first, let’s explore what components actually are and how we can build a site based on such components, and finally, explore how a component-based API works. Introducing The Component-Based API.

Social Media 64

Social Media Database Media Website 64

Enprowess

SEPTEMBER 7, 2021

If you wish to find out which one to choose for your next project, read this article. has a unit testing framework called Jasmine, which allows unit testing of code during development. It makes code very easy to understand and launch. Stable code: With downward data flow, React.js Caching of individual modules.

Open Source 52

Open Source Virtualization Programming Servers 52

SQL Performance

MAY 29, 2019

The FastLoadContext code path adds support for minimally-logged and concurrent bulk load on: Empty and non-empty clustered b-tree indexes. Otherwise, rows from the ordered insert stream are added to a brand new page using an optimized, and minimally-logged code path. GO. -- Clear the plan cache. No secondary indexes. INSERT dbo.

Cache 64

Cache Testing Servers Code 64

SQL Server According to Bob

JANUARY 11, 2020

KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? KB boundary   12 Larger transaction logs   13 Restore and attach   14 Format for 4 ?KB

Servers 40

Servers Cache Database Media 40

Smashing Magazine

JANUARY 15, 2019

The Green Web Foundation maintains an ever-growing database of web hosts who are either wholly powered by renewable energy or are at least committed to being carbon neutral. You can read about more advanced dead code elimination (aka tree shaking) in this post for Google by Jeremy Wagner. Write CSS Like Your Grandmother.

Website Performance 73

Website Performance Website Energy Performance 73

Highly Scalable

AUGUST 20, 2013

This article is an effort to explore techniques used by developers of in-stream data processing systems, trace the connections of these techniques to massive batch processing and OLTP/OLAP databases, and discuss how one unified query engine can support in-stream, batch, and OLAP processing at the same time.

Big Data 154

Big Data Processing Lambda Database 154

SQL Performance

NOVEMBER 22, 2019

For the difference between the two, please see my article Apply versus Nested Loops Join. An AdventureWorks sample database example is shown below: SELECT. The next code example shows a DMV query that is successfully converted from a join to an apply. That means that the join needs to be an apply , not a nested loops join.

Servers 77

Servers Cache Database Performance 77

Jos

JUNE 2, 2018

There was something gratifying in taking a code that takes minutes to run and make it run in a handful seconds. Normally the team decides how well to cover and test the code, and it’s important that all developers in a team know how to write tests. That way you won’t merge nor deploy code that decreases the performance.

Performance 130

Performance Speed Google Media 130

SQL Performance

MARCH 8, 2021

This article aims to help you understand where the timings come from in each case, and how they can be best interpreted in context. The following examples use the public Stack Overflow 2013 database ( download details ), with a single index added: CREATE INDEX PP ON dbo. The clock keeps running at the same rate even during sleep.

Servers 95

Servers Tuning Architecture Processing 95

Enprowess

JANUARY 12, 2022

So it is convenient for all to use irrespective of internet speed and it works offline using cached data. Easy Deployment: PWAs can be deployed easily using a single code base that runs on accelerated mobile pages and web browsers. Blockchain technology is an encrypted database storage system. Serverless Architecture.

Blockchain 59

Blockchain IoT Development Serverless 59

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. Egnyte Connect Platform.

Architecture 52

Architecture Cache Azure Storage 52