SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. This is very efficient, as confirmed by the elapsed time of 13ms (all of which is CPU time). The structure of a b-tree index makes finding the next highest value very efficient — there is no need to scan through the duplicates. Test Environment.

Servers 86

Servers Tuning Database Efficiency 86

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. Various partition types, like RANGE, LIST, HASH, and KEY, are used for specific needs, from range-based data to custom criteria, to ensure efficient data handling and the optimization of queries. So, What is MySQL Partitioning?

Strategy 40

Strategy Storage Database Best Practices 40

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

O'Reilly Software

APRIL 4, 2018

The data shape will dictate capacity planning, tuning of the backbone, and scalability analysis for individual components. A message-oriented implementation requires an efficient messaging backbone that facilitates the exchange of data in a reliable and secure way with the lowest latency possible. At least once? At most once?

Architecture 80

Architecture Scalability Google Operating System 80

Smashing Magazine

JUNE 3, 2022

Our focus is on typefaces for reading large amounts of text and information in the most efficient, legible, pleasurable, comprehensible, and effective way possible. Stay tuned! Measuring The Performance Of Typefaces For Users (Part 1). Thomas Bohm. 2022-06-03T10:00:00+00:00. 2022-06-03T14:03:11+00:00.

Performance 111

Performance Design Best Practices Testing 111

Randon ASCII

APRIL 17, 2018

When you own all of the code then this may involve some back of the envelope estimates, competitive benchmarking, or intuition tuned by experience. Hey Microsoft – I’ve got a cool idea for how you can make file notifications more efficient. Another instance of this problem was hit in November 2017 and is described here.

Monitoring 43

Monitoring C++ Code Processing 43

John McCalpin

JANUARY 22, 2018

Introduction: In December 2017, my colleague Damon McDougall (now at AMD) asked for help in porting the fused multiply-add example code from a Colfax report ( [link] ) to the Xeon Phi x200 (Knights Landing) processors here at TACC. of the “adjusted peak performance”, there is no longer a significant upside to performance tuning.

Latency 40

Latency Hardware Code Testing 40

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. STRING_SPLIT() in SQL Server 2016 : Follow-Up #1.

C++ 59

C++ Servers Testing Database 59