Smashing Magazine

JANUARY 15, 2019

So, apart from powering servers with renewable energy, what else can web developers do about climate change? This includes the work done by the server, the client and the intermediary communications networks that transmit data between the two. In 2016, O’Reilly published “ Designing For Sustainability ” by Tim Frick.

Website Performance 73

Website Performance Website Energy Performance 73

Percona

JANUARY 24, 2023

Some of the built-in features ( wal_compression ) have been there since 2016, and almost all backup tools do the WAL compression before taking it to the backup repository. Zstd can be chosen if the server load is not CPU bound because it can give us better compression at the expense of more CPU utilization.

Database 119

Database Benchmarking Open Source Latency 119

SQL Performance

AUGUST 23, 2019

In traditional row-mode execution plans, SQL Server may introduce a Bitmap operator as part of performing early semi join reduction before a parallel hash or merge join. There have been major improvements since the first appearance of the batch mode execution engine in SQL Server 2012. Background. The Query Optimizer. Bitmap Choice.

Servers 75

Servers Engineering Efficiency Retail 75

All Things Distributed

DECEMBER 13, 2016

AWS is not only affordable but it is secure and scales reliably to drive efficiencies into business transformations. In just this past month we've had HSBC , ARM , Missguided , and most recently at re:Invent 2016 , Trainline , talking with us about how they are using AWS to transform and scale their businesses.

AWS 166

AWS Cloud Artificial Intelligence IoT 166

Brendan Gregg

NOVEMBER 29, 2017

Paravirtualization**: The hypervisor provides efficient hypercalls, and the guest OS uses drivers and kernel modifications to call these hypercalls. Enter paravirtualization, originally introduced in Xen, where the guest has been modified to be aware of the hypervisor and to make efficient hypercalls. The AMI and boot are now HVM.

Virtualization 111

Virtualization AWS Hardware Storage 111

SQL Performance

SEPTEMBER 5, 2019

I briefly mentioned that batch mode data is normalized in my last article Batch Mode Bitmaps in SQL Server. You will need SQL Server 2016 (or later) and Developer Edition (or equivalent) to reproduce the results shown here. This table uses columnstore for its primary storage to produce batch mode execution later on.

Performance 81

Performance C++ Storage Servers 81

Brendan Gregg

NOVEMBER 28, 2017

Paravirtualization**: The hypervisor provides efficient hypercalls, and the guest OS uses drivers and kernel modifications to call these hypercalls. Enter paravirtualization, originally introduced in Xen, where the guest has been modified to be aware of the hypervisor and to make efficient hypercalls. The AMI and boot are now HVM.

Virtualization 40

Virtualization AWS Hardware Storage 40

SQL Performance

APRIL 23, 2019

In SQL Server 2012, grouped (vector) aggregation was able to use parallel batch-mode execution, but only for the partial (per-thread) aggregate. SQL Server 2014 added the ability to perform parallel batch-mode grouped aggregation within a single Hash Match Aggregate operator. Columnstore storage. Introduction.

Servers 67

Servers Testing Metrics Storage 67

Brendan Gregg

SEPTEMBER 5, 2017

LTS (April 2016). I wrote about it in a previous post, [DTrace for Linux 2016]. I wrote a page on it: [perf]. - **eBPF**: tracing features completed in 2016, this provides efficient programmatic tracing to existing kernel frameworks. Oracle VM Server is based on Xen. It's the official profiler. amazon").

Virtualization 76

Virtualization AWS Engineering Hardware 76

Alex Russell

OCTOBER 22, 2017

Late-loading JavaScript can cause “server-side rendered” pages to fail in infuriating ways. The server sends it as a stream of bytes and when the browser encounters each of the sub-resources referenced in the document, it requests them. The true median device from 2016 sold at about ~$200 unlocked.

Performance 68

Performance Benchmarking Network Mobile 68

Percona

JANUARY 14, 2019

However, ClickHouse is super efficient for timeseries and provides “sharding” out of the box (scalability beyond one node). Although such databases can be very efficient with counts and averages, some queries will be slow or simply non existent. Inserts are efficient for bulk inserts only. created_utc?? ?

Database 40

Database Analytics Blockchain Healthcare 40