SQL Performance

DECEMBER 9, 2020

In a comment to my article, Marcos Kirchner mentioned that he tested my solution with varying table value constructor cardinalities, and got different execution times for the different cardinalities. If so, share yours as a comment to this article, and feel free to improve any solution posted by others.

C++ 114

C++ Servers Testing Processing 114

CSS Wizardry

NOVEMBER 3, 2020

my about page ), and article pages, like this one you’re reading right now; an ecommerce site would have a homepage, a product listings page (PLP), a product details page (PDP), and a search results page (SRP). For now, I’m usually sat with a coffee, some tunes on, and an old-school pen and paper making notes.

Speed 292

Speed Ecommerce Metrics Analytics 292

Sutter's Mill

MAY 28, 2012

It’s time for, not one, but two brand-new, up-to-date talks on the state of the art of concurrency and parallelism in C++. I’m going to put them together especially and only for C++ and Beyond 2012 , and I’ll be giving them nowhere else this year: C++ Concurrency – 2012 State of the Art (and Standard). And there’s a lot to tell.

C++ 40

C++ Hardware Best Practices Tuning 40

Brendan Gregg

SEPTEMBER 25, 2021

As (C) looked like a kernel rebuild, I started with (D) and (E). ## 5. I also rewrote this in C and called gettimeofday(2) directly: $ cat gettimeofdaybench.c. Over the years, more and more articles have been published about clocksource in virtual machines, and it's now a well-known issue. Try changing the kernel clocksource.

Speed 126

Speed Java AWS Virtualization 126

SQL Performance

APRIL 8, 2020

This article is the first in a series about the fundamentals of table expressions in T-SQL. If you can bear with me a bit, I'll provide the reasoning for my view of things in this article. When I read C. I was inspired to write this series by my good friend, Grant Fritchey , whom I have known for many years. There are many more.

C++ 143

C++ Azure Database Servers 143

SQL Performance

DECEMBER 9, 2020

In a comment to my article, Marcos Kirchner mentioned that he tested my solution with varying table value constructor cardinalities, and got different execution times for the different cardinalities. If so, share yours as a comment to this article, and feel free to improve any solution posted by others.

C++ 61

C++ Servers Testing Processing 61

Smashing Magazine

AUGUST 9, 2021

These statements and articles typically skip over some crucial technical details , are lacking in nuance, and usually are only partially correct. In this article series, I will discuss the new protocol, especially its performance features , with more nuance. We will discuss these features in more depth later in this article.

Transportation 145

Transportation Internet Internet Network 145

Smashing Magazine

APRIL 13, 2020

On top of basic font style properties, we can now reliably fine-tune OpenType figures, hyphenation, ligatures, and even kerning. This creates an asymmetrical design with a column of white space between my main content and the articles which support it: main { grid-column: 1; } aside { grid-column: 3 / -1; } }. Reordering And Rotating.

Design 116

Design Media C++ Technology 116

Smashing Magazine

SEPTEMBER 13, 2021

This article will walk you through the main points and techniques that might help you deal with complex animations while staying flexible. Before we dive into the article it is vital that you’re familiar with the basics of the Web Animations API and JavaScript. Web Animations API gives you a lot of tools to work with animations.

Media 96

Media Tuning Design Code 96

Percona

JANUARY 28, 2019

EverSQL (use code PERCONA-EVERSQL-10OFF for a 10% discount on the first billing cycle) is a platform that intelligently tunes your SQL queries by providing query optimization recommendations, and feedback on missing indexes. We’ll use the Stackoverflow data set again as we did in our first post. And why did it work so well?

Monitoring 42

Monitoring C++ Tuning Analytics 42

Rigor

JANUARY 13, 2020

Reading time 1 min Why share the library of the web performance books while there’s a substantial collection of fantastic websites and articles on the net? Steve Souders, plus Dion Almaer, Doug Crockford, Ben Galbraith, Tony Gentilcore, Dylan Schiemann, Stoyan Stefanov, Nicole Sullivan, Nicholas C. Web Performance Tuning.

Performance 75

Performance Social Media Website Website Performance 75

HammerDB

JANUARY 5, 2019

For example the following chart (with the actual data removed for the reasons described further in this post) shows the HammerDB TPC-C workload run against the same database on different processing architectures (grouped by colour) and speed with the most recent at the top.

Benchmarking 40

Benchmarking Database Social Media Scalability 40

Sutter's Mill

DECEMBER 4, 2012

On yesterday’s thread, I just wrote in a comment: @Jon: Yes, C++ is complex and the complexity is largely because of C compatibility. So just as C++ ‘won’ in the 90s because of its own strengths plus its C compatibility, C++11 is being adopted because of its own strengths plus its C++98 compatibility.

C++ 40

C++ Tuning Programming Engineering 40

Smashing Magazine

AUGUST 22, 2021

HTTP/3 performance features ( current article ). This has led to many articles claiming that QUIC also doesn’t use congestion control, that QUIC can instead start sending data at a much higher rate over UDP (relying on the removal of HOL blocking to deal with packet loss), that this is why QUIC is much faster than TCP.

Performance 106

Performance Network Latency Servers 106

Brendan Gregg

SEPTEMBER 25, 2021

As (C) looked like a kernel rebuild, I started with (D) and (E). ## 6. I also rewrote this in C and called gettimeofday(2) directly: $ cat gettimeofdaybench.c Over the years, more and more articles have been published about clocksource in virtual machines, and it's now a well-known issue. Try changing the kernel clocksource.

Speed 40

Speed Java AWS Virtualization 40

Percona

JANUARY 17, 2019

In this article, we will look at how this can improve the reporting/analytical query performance in MySQL. According to Jeff Barr’s excellent article ( [link] ) the following instance classes will support parallel query (PQ): “The instance class determines the number of parallel queries that can be active at a given time: db.r*.large

Cache 46

Cache C++ AWS Airlines 46

Smashing Magazine

JUNE 26, 2020

As the letter d is used for two adjacent areas, the item placed using that letter will occupy both: body { grid-template-areas: "a b c" "d d e" "f g h"; }. CSS transforms are ideal tools for fine-tuning the size and position of elements within grids’ constraints. They’re also useful for adding unusual touches to a design.

Design 95

Design Media C++ Energy 95

HammerDB

NOVEMBER 5, 2018

If you are new to running Oracle, SQL Server, MySQL and PostgreSQL TPC-C workloads with HammerDB and have needed to investigate I/O performance the chances are that you have experienced waits on writing to the Redo, Transaction Log or WAL depending on the database you are testing. A good example of how tuning is an iterative process.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

Smashing Magazine

SEPTEMBER 6, 2021

Practical HTTP/3 deployment options ( current article ). You would, however, be hard-pressed even today to find a good article that details the nuanced best practices. As such, a micro-optimization is, again, how you probably need to fine-tune things on a low level to really benefit from it. HTTP/3 performance features.

Network 105

Network Servers Cache Traffic 105

SQL Performance

SEPTEMBER 2, 2021

I’ve written several articles about this function (and STRING_AGG, which arrived in SQL Server 2017) since this post was written: Performance Surprises and Assumptions : STRING_SPLIT(). He spent a lot of time fine-tuning this CLR function to efficiently parse a string. all_columns AS c WHERE EXISTS. ( WHERE Item = c.

C++ 59

C++ Servers Testing Database 59

Smashing Magazine

AUGUST 18, 2020

C Stands for Constitution designed by Bradbury Thompson. I need to place the content of my header and article directly onto my grid, so I change those elements’ display property to contents, which effectively removes them for styling purposes: header, article { display: contents; }. Large preview ). Left: Monochrome.

Design 119

Design Media Entertainment Website 119

Smashing Magazine

NOVEMBER 24, 2021

A” is for “Albert”, “B” is for “Bounce”, “C” for “Cowabunga”. A great place to seek fresh inspiration — or just discovering some new tunes to get you through a lengthy coding session. It’s that mix of the unforeseen that makes the showcase so refreshing despite its monochromatic color palette. An Alphabetical Adventure. “A”

Website 122

Website Design Games Open Source 122

Brendan Gregg

SEPTEMBER 5, 2017

I wrote an ftrace toolkit, [perf-tools], and the article [Ftrace: the hidden light switch]. - **perf**: since 2009, this started as a PMC profiler but can do tracing now as well, usually in a dump-and-post-process style. Hit Ctrl-C to end. ^C It's the official profiler. Tracing ZFS operation latency.

Virtualization 76

Virtualization AWS Engineering Hardware 76

Percona

JANUARY 14, 2019

This time I’m trying to find the news keywords of the year using all reddit comments: basically I’m calculating the most frequently used new words for the specific year (algorithm based on an article about finding trending topics using Google Books n-grams data ).

Database 40

Database Analytics Blockchain Healthcare 40

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. Java/Python mostly and some small services in Go/C. Adding fingerprint to each database query by inspired by some article at [link]. Cloud Platform.

Architecture 52

Architecture Cache Azure Storage 52

SQL Server According to Bob

JANUARY 11, 2020

​​ The following is an excerpt from ​​ the ​​ Exchange ​​ Server ​​ Knowledge ​​ Base article ​​ KB1517 8 9. Then ​​ write C ​​ obtains ​​ 01 ​​ and so on.

Servers 40

Servers Cache Database Media 40