SQL Performance

APRIL 8, 2020

As Grant repeatedly points out, many who use common table expressions in T-SQL think that SQL Server persists the inner query result set, and that the reason for this belief is the use of the term table in the construct's name. Date (O'Reilly 2015). In my examples I'll use a sample database called TSQLV5.

C++ 143

C++ Azure Database Servers 143

SQL Performance

OCTOBER 14, 2020

In my examples I’ll continue using the sample databases TSQLV5 and PerformanceV5. The issue is that even though SQL Server does support a short circuit concept at the physical processing level, there’s no assurance that it will evaluate the filter predicates in written order from left to right. Substitution/unnesting.

C++ 140

C++ Servers Code Efficiency 140

All Things Distributed

JANUARY 6, 2016

Mirae Asset Global Investments improved its web service environment and reduced annual management costs by 50% by consolidating the management of all web services, including servers, network, database, and security. Finally, the Seoul Region brings the benefits of the cloud much closer to home for Korean startups.

AWS 110

AWS Cloud Games Latency 110

Percona

JANUARY 17, 2019

I will compare AWS Aurora with MySQL (Percona Server) 5.6 84.1 | | version_comment | Percona Server (GPL), Release 84.1, 84.1 | | version_comment | Percona Server (GPL), Release 84.1, AWS Aurora (based on MySQL 5.6) MySQL on ec2. MySQL on ec2.

Cache 46

Cache C++ AWS Airlines 46

SQL Server According to Bob

JUNE 3, 2016

SQL Server 2016 ‘It Just Runs Faster’ A bold statement that any SQL Server professional can stand behind with confidence. Try SQL Server 2016 Today. The SQL Server Development team tasked several individuals with scalability improvements and real world testing patterns. – [link]. Follow-up.

Hardware 40

Hardware Software Engineering Transportation Scalability 40

SQL Performance

OCTOBER 14, 2020

In my examples I’ll continue using the sample databases TSQLV5 and PerformanceV5. The issue is that even though SQL Server does support a short circuit concept at the physical processing level, there’s no assurance that it will evaluate the filter predicates in written order from left to right. Substitution/unnesting.

C++ 52

C++ Servers Code Efficiency 52

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. This server is spending about a third of its CPU cycles just checking the time! What on Earth is Ubuntu doing that results in 30% higher CPU time!?

Speed 40

Speed Java AWS Virtualization 40

Jos

JUNE 2, 2018

How would you architecture a non-trivial size web project (client, server, databases, caching layer)? How do you scale it through different servers? In May 2015, Vox Media wrote about the slowness of their site and commitment to make them faster. What happens when a browser tries to load a website? When will that be run?

Performance 237

Performance Speed Google Media 237

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. This server is spending about a third of its CPU cycles just checking the time! What on Earth is Ubuntu doing that results in 30% higher CPU time!?

Speed 52

Speed Java AWS Virtualization 52

Brendan Gregg

NOVEMBER 29, 2017

But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. Xen AWS 2017 In 2015, AWS launched c4, which used hardware virtualization for EBS volumes. AWS Bare Metal 2017 Also announced at AWS re:Invent: the Amazon EC2 Bare Metal instances, which are just that – bare metal servers.

Virtualization 111

Virtualization AWS Hardware Storage 111

All Things Distributed

AUGUST 16, 2011

The move to the cloud is projected by 2015 see a reduction of 30% in IT infrastructure costs, which amounts to $7.2 a Fast and Scalable NoSQL Database Service Designed for Internet Scale Applications. Job Openings in AWS - Senior Leader in Database Services. No Server Required - Jekyll & Amazon S3.

AWS 113

AWS Government Big Data Cloud 113

Smashing Magazine

APRIL 1, 2020

Many Jamstack sites created with static site generators like Gridsome, Hugo or Gatsby make use of the headless CMS to manage content, they cannot access a database, Hence content can be stored in a headless CMS and fetched through an API during build time and deployed as static files. This is data received from the server.

Open Source 103

Open Source Website Mobile Code 103

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?

Performance 145

Performance Cache Network Metrics 145

Enprowess

JANUARY 12, 2022

Internet of things (IoT) – Number of IoT devices 2015-2025 Statista. IBM OpenWhisk, Microsoft Azure, AWS Lambda, and Google Cloud Functions are famous names that provide server-less services. Blockchain technology is an encrypted database storage system. trillion US dollars, and there will be more than 75.50 Smart cities.

Blockchain 59

Blockchain IoT Development Serverless 59

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

Jos

JUNE 2, 2018

How would you architecture a non-trivial size web project (client, server, databases, caching layer)? How do you scale it through different servers? In May 2015, Vox Media wrote about the slowness of their site and commitment to make them faster. What happens when a browser tries to load a website? When will that be run?

Performance 130

Performance Speed Google Media 130

Brendan Gregg

NOVEMBER 28, 2017

But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. Xen AWS 2017 In 2015, AWS launched c4, which used hardware virtualization for EBS volumes. AWS Bare Metal 2017 Also announced at AWS re:Invent: the Amazon EC2 Bare Metal instances, which are just that – bare metal servers.

Virtualization 40

Virtualization AWS Hardware Storage 40

Alex Russell

MARCH 6, 2021

Devices and networks have evolved too: Alex Russell @slightlylate An update on mobile CPUs and the Performance Inequality Gap: Mid-tier Android devices (~$300) now get the single-core performance of a 2014 iPhone and the multi-core perf of a 2015 iPhone. The cheapest (high volume) Androids perform like 2012/2013 iPhones, respectively.

Performance 124

Performance Network Cache Metrics 124

The Netflix TechBlog

DECEMBER 17, 2019

Andreas Andreakis , Ioannis Papapanagiotou Overview Change-Data-Capture (CDC) allows capturing committed changes from a database in real-time and propagating those changes to downstream consumers [1][2]. In databases like MySQL and PostgreSQL, transaction logs are the source of CDC events. Designed with High Availability in mind.

Database 212

Database Traffic Transportation Open Source 212

The Netflix TechBlog

DECEMBER 17, 2019

Andreas Andreakis , Ioannis Papapanagiotou Overview Change-Data-Capture (CDC) allows capturing committed changes from a database in real-time and propagating those changes to downstream consumers [1][2]. In databases like MySQL and PostgreSQL, transaction logs are the source of CDC events. Designed with High Availability in mind.

Database 197

Database Traffic Transportation Open Source 197

All Things Distributed

APRIL 4, 2017

In 2014 and 2015 respectively, AWS opened offices in Stockholm and Espoo, Finland. After migrating, database queries that took six seconds now take three seconds in their AWS infrastructure. This has led us to steadily increase our investment in the Nordics to serve our growing base of enterprise, public sector, and startup customers.

AWS 117

AWS Airlines Latency Games 117