CSS - Tricks

JULY 18, 2019

The irony of web performance is that the average page weight of a site continues to go up year after year, despite us being more aware of the problem and having more tools at our disposal to fight it than ever. They made it so that performance is integrated right into managing content on a WordPress site. That's pretty awesome!

Performance 41

Performance Storage Speed Servers 41

The Morning Paper

OCTOBER 4, 2020

Understanding operational 5G: a first measurement study on its coverage, performance and energy consumption , Xu et al., The study is based on one of the world’s first commercial 5G network deployments (launched in April 2019), a 0.5 SIGCOMM’20. km university campus. The 5G network is operating at 3.5GHz).

Energy 130

Energy Latency Performance Network 130

Percona

DECEMBER 20, 2018

Let’s look at some of the most popular Percona Database Performance Blog posts in 2018. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open source community with insights, technical support, predictions and metrics around multiple open source database software technologies.

Database 40

Database Tuning Performance AWS 40

Percona

AUGUST 17, 2023

StackOverflow statistics show that 26% of developers preferred it in 2017, 34% in 2019, and 40% in 2021. PostgreSQL has powerful and advanced features, including asynchronous replication, full-text searches of the database, and native support for JSON-style storage, key-value storage, and XML.

Open Source 78

Open Source Healthcare Social Media Database 78

High Scalability

APRIL 3, 2019

PostgreSQL is an open source object-relational database system that has soared in popularity over the past 30 years from its active, loyal, and growing community. For the 2nd year in a row, PostgreSQL has kept the title of #1 fastest growing database in the world according to the DBMS of the Year report by the experts at DB-Engines.

Database 177

Database Cloud Open Source Systems 177

Smashing Magazine

JANUARY 15, 2019

How Improving Website Performance Can Help Save The Planet. How Improving Website Performance Can Help Save The Planet. 2019-01-15T13:30:32+01:00. 2019-04-29T18:34:58+00:00. So, apart from powering servers with renewable energy, what else can web developers do about climate change? Jack Lenox.

Website Performance 73

Website Performance Website Energy Performance 73

Smashing Magazine

NOVEMBER 8, 2018

Sharing Data Among Multiple Servers Through AWS S3. Sharing Data Among Multiple Servers Through AWS S3. 2019-04-29T18:34:58+00:00. After the file is uploaded to a server on step 1, the file must be available to whichever server handles the request for steps 2 and 3, which may or may not be the same one for step 1.

AWS 44

AWS Servers Storage Cloud 44

Scalegrid

SEPTEMBER 16, 2019

You can remotely access and navigate another database server. The dashboard lets you monitor server activities such as database locks, connected sessions, and prepared transaction. Since pgAdmin is a web application, you can deploy it on any server and access it remotely. 2019 Comparison Click To Tweet.

Open Source 262

Open Source Database Azure Cloud 262

SQL Performance

AUGUST 27, 2021

When you enable one of the two forms of versioning, SQL Server uses a mechanism called versioning to preserve pre-change versions of a record in the version store in tempdb. This special-purpose storage is made up of append-only allocation units and is only used for version store operations.

Database 56

Database Storage Availability Servers 56

Smashing Magazine

AUGUST 23, 2019

2019-08-23T13:30:59+02:00. 2019-08-23T13:06:42+00:00. The idea presented here is now to load only so many bytes of a progressive JPEG from the server that you can quickly get an impression of the image content. With Ajax, however, this is possible, provided that the server delivering the image supports HTTP Range Requests.

Network 103

Network Servers Programming Code 103

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. “.

Servers 90

Servers Media Cache Storage 90

Smashing Magazine

MARCH 28, 2019

2019-03-28T10:30:39+01:00. 2019-04-29T18:34:58+00:00. Because server technology is rarely understood by the people who own websites, it’s easy for them to mistakenly think they can save money there. You build an amazing website that aims to do exactly what your client wanted, but the server technology is holding it back.

Website 48

Website Servers Design Traffic 48

SQL Performance

OCTOBER 7, 2020

For more background on these performance spools see my prior article. The first three items are most often performance spools, though they can be introduced for other reasons (when they may be eager as well as lazy). The documentation says only the following operators can rewind: Table Spool. Row Count Spool. Nonclustered Index Spool.

Servers 106

Servers Cache Azure Performance 106

Scalegrid

OCTOBER 7, 2019

As this open source database continues to pull new users from expensive commercial database management systems like Oracle, DB2 and SQL Server, organizations are adopting new approaches and evolving their own to maintain the exceptional performance of their SQL deployments. autovacuum may have trouble keeping up on a busy server.

Strategy 182

Strategy Cloud Java Open Source 182

Percona

JULY 7, 2023

It enables businesses and organizations to meet uptime and service level objectives, protect business-critical data, and maintain performant databases. Failover: This functionality is all about switching — in both unplanned and planned situations — from a failed primary server to a standby server.

Availability 83

Availability Open Source Architecture Database 83

Alex Russell

MARCH 6, 2021

Back in 2016, I gave a talk outlining the causes and effects of the terrible performance of web apps built using popular tools on the fastest-growing device segment: low-end to mid-range Android phones. Poor performance has a compound effect on user expectations at an ecosystem level. Live by the link, die by the link.

Performance 124

Performance Network Cache Metrics 124

Percona

JULY 15, 2023

While indexes enhance query performance by reducing the need for full-table scans, some things need consideration: Choosing Appropriate Columns : Optimal column selection for indexing holds significance. Balancing Index Size and Query Performance : The size of an index impacts its performance; larger indexes may slow down query processing.

Virtualization 77

Virtualization Speed Database Efficiency 77

SQL Performance

FEBRUARY 3, 2020

While I got decent results in my first attempt, I wanted to see if I could improve the performance in part 2. There I outlined a few of the things I thought might be performance issues, and laid out how I would better partition the destination table for optimal columnstore compression. Other Testing. tblOriginal.

Speed 113

Speed Processing Servers Storage 113

Dynatrace

JULY 8, 2020

A container (or a pod) running on a node may eat up all the available CPU or memory and affect all other pods on the node, degrading performance (or worse) and preventing any new workload to be scheduled on the node. When Kubernetes perform autoscaling (up/down) and on what. By default, containers run with unbounded limits.

Infrastructure 198

Infrastructure Monitoring Cloud Metrics 198

SQL Server According to Bob

MAY 19, 2019

SQL Server will ship Azure SQL Database Edge: [link]. With the announcement I can tell you more about one of the things we have been working on; SQL Server running on IoT Edge and Developer machines in under 500MB of memory. The effort focuses attention on memory usage and disk space requirements of SQL Server.

IoT 61

IoT Servers Development Cache 61

The Morning Paper

NOVEMBER 8, 2020

While ultimately this new system should be able to take advantage of the latest advances in consensus for improved performance, that’s not realistic given a 6-9 month in-production target. replacing Paxos with Raft), or they could be shims over external storage systems. What Facebook needed, literally, was a plan to throw one away.

Virtualization 126

Virtualization Latency Storage Systems 126

SQL Performance

NOVEMBER 13, 2019

Never mind the likelihood for this to happen in practice in SQL Server; if I run the query again, theoretically, the row with id 2 could be assigned with row number 3 and the row with id 11 could be assigned with row number 2. So apparently the window order clause is mandatory for the ROW_NUMBER function in SQL Server.

Servers 104

Servers C++ Storage Performance 104

SQL Performance

AUGUST 27, 2019

On August 7, 2019, AMD finally unveiled their new 7nm EPYC 7002 Series of server processors, formerly code-named "Rome" at the AMD EPYC Horizon Event in San Francisco. This is the second generation EPYC server processor that uses the same Zen 2 architecture as the AMD Ryzen 3000 Series desktop processors.

Servers 52

Servers Benchmarking Virtualization Architecture 52

SQL Performance

APRIL 27, 2020

Many of the newer features we have in SQL Server were initially launched in Azure SQL Database, including (but not limited to) Always Encrypted, Dynamic Data Masking, Row Level Security, and Query Store. The basic tier provides up to 5 DTUs with standard storage. vCore Pricing Tier. GB per vCore. HyperScale Database.

Azure 55

Azure Database Serverless Hardware 55

Dynatrace

JANUARY 15, 2020

Having released this functionality in an Preview Release back in September 2019, we’re now happy to announce the General Availability of our Citrix monitoring extension. This extends Dynatrace visibility into Citrix user experience and Citrix platform performance. Dynatrace Extension: SAP ABAP platform performance.

Latency 36

Latency Performance Virtualization Infrastructure 36

SQL Performance

SEPTEMBER 6, 2022

I happen to be using SQL Server 2019 CU16 but the details I’ll describe haven’t materially changed since partition level lock escalation was added to SQL Server 2008. The SQL Server lock manager keeps track of the number of locks held by the current transaction. Testing environment. Well, almost. The sqlmin!lck_lockInternal

Database 98

Database Storage Testing Servers 98

Percona

JULY 3, 2023

Partitioning is the concept of splitting large tables logically into smaller pieces for better performance of the database. However, a rule of thumb is that the size of the table should exceed the physical memory of the database server. The exact point at which a table will benefit from partitioning depends on the application.

Storage 82

Storage Database Performance Open Source 82

HammerDB

JUNE 27, 2022

It enables the user to measure database performance and make comparative judgements about database hardware and software. The Transaction Processing Performance Council (TPC) was founded to bring standards to database benchmarking, and the history of the TPC can be found here. What is HammerDB? Why HammerDB was developed.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

HammerDB

OCTOBER 12, 2018

This post complements the previous best practice guides this time with the focus on MySQL and MariaDB and achieving top levels of performance with the HammerDB MySQL TPC-C test. As is exactly the same with PostgreSQL for system choice a 2 socket system is optimal for MySQL OLTP performance. HammerDB difference from Sysbench.

Best Practices 40

Best Practices Scalability Performance C++ 40

SQL Performance

NOVEMBER 30, 2021

SQL Server has a cost-based optimizer that uses knowledge about the various tables involved in a query to produce what it decides is the most optimal plan in the time available to it during compilation. Whether the page is dirty or not (a dirty page has changes on it that haven’t yet been written back to durable storage). ) ; GO.

Efficiency 54

Efficiency Servers Database Cache 54

SQL Performance

APRIL 8, 2019

Back on December 5, 2017, Microsoft announced that they were using AMD EPYC 7551 processors in their storage-optimized Lv2-Series virtual machines. These AMD EPYC processors have a number of advantages for SQL Server workloads, as I will explain in this article. Since then, Microsoft has changed the naming of this series to Lsv2.

Azure 42

Azure Virtualization Storage Benchmarking 42

Smashing Magazine

SEPTEMBER 26, 2019

2019-09-26T12:30:59+02:00. 2019-09-26T11:02:12+00:00. This flexible approach is well-established and widely-adopted by back-end and server architects. There are several ways you can organize Host and Alien: Different domains or IP addresses; Different folders on your server; git submodules ; And so on. Denys Mishunov.

Architecture 74

Architecture Virtualization Servers Technology 74

Smashing Magazine

OCTOBER 22, 2019

2019-10-22T12:30:59+02:00. 2019-10-22T13:06:35+00:00. Plus, now that Google has made mobile-first indexing the default, you really can’t afford to let any performance optimizations fall by the wayside what with how difficult it can be to get your mobile site as speedy as your desktop. A Guide To Optimizing Images For Mobile.

Mobile 63

Mobile Media Website Storage 63

Testsigma

NOVEMBER 16, 2021

In the summer of 2019, British Airways faced a technical issue on its website. Considering this requirement and the website load, enterprises generally set up multiple servers and machines that can talk to each other through a network. This includes the design principles, server communications or data transfers and storage.

Testing 52

Testing Website Small Business Internet 52

O'Reilly

JULY 25, 2023

For instance, if I’m reading a paper from 2019, a popular song from that year could start playing. In the end, I had to add four additional permissions—”tabs”, “storage”, “scripting”, “identity”—as well as a separate “host_permissions” field to my manifest.json.

Programming 98

Programming Code Design Benchmarking 98

Smashing Magazine

OCTOBER 29, 2019

2019-10-29T12:30:59+02:00. 2019-10-29T13:36:09+00:00. Even if you resize your images to the exact specifications of your website and run them through a compressor, they can still put a strain on performance and run up bandwidth usage. Still, it takes a bit of work to modify the origin servers to make this happen.

Website 72

Website Speed Cache Google 72

Smashing Magazine

SEPTEMBER 27, 2019

2019-09-27T12:00:59+02:00. 2019-09-27T10:38:23+00:00. In this article, we’ll be putting all the theory to the test by performing step-by-step migration of an application, following the recommendations from the previous part. Restart your server if needed and witness the magic of the Alien component integrated into Host.

Storage 67

Storage Testing Processing Code 67