SQL Performance

APRIL 20, 2021

A reminder of the plan ( click to enlarge ): This is the first point in the process so far that an in-flight execution plan is available (SQL Server 2016 SP1 onward) in sys.dm_exec_query_statistics_xml. Additional parallel workers will be started to run the additional parallel tasks contained in branches B, C, and D.

C++ 98

C++ Processing Servers Cache 98

Percona

JANUARY 17, 2019

On multi-core machines – which is the majority of the hardware nowadays – and in the cloud, we have multiple cores available for use. Aurora Parallel Query response time (for queries which can not use indexes) can be 5x-10x better compared to the non-parallel fully cached operations. The second and third run used the cached data.

Cache 46

Cache C++ AWS Airlines 46

Smashing Magazine

JULY 6, 2021

With Luminary’s 21 years of experience in the digital space, my experience of 17 years in the CMS space as well as our focus on Headless since 2016, here are my two cents on what you should look out for. But where do they preview the content before it is made available to the general public? Microservices architecture. Omnichannel.

Cache 143

Cache Website Mobile Google 143

Adrian Cockcroft

JANUARY 29, 2023

I presented this analysis of response time distributions talk in 2016 — at Microxchg in Berlin ( video ). A later version of the slides is included in my Microservices Workshop deck from later that year, slides 168–200 ( pdf , keynote are available in GitHub.com/adrianco/slides ). I’ve been thinking about this for a long time.

Lambda 98

Lambda Latency Cache C++ 98

SQL Performance

SEPTEMBER 25, 2019

The general idea is to cache and replay results, saving repeated executions of inner-side operators wherever possible. When a spool is able to replay cached results, this is known as a rewind. You may find it helpful to think of a spool rebind as a cache miss, and a rewind as a cache hit. Lazy Table Spool.

Performance 104

Performance Cache Servers Education 104

Percona

JUNE 4, 2023

Critical features of MariaDB include robust security features like encryption at rest and in transit, user authentication, and role-based access control (RBAC), as well as high-performance query execution, advanced indexing techniques, and replication, clustering, and sharding, ensuring scalability and high availability.

Open Source 52

Open Source Servers Storage Scalability 52

John McCalpin

NOVEMBER 5, 2016

In the latest (October 2016) revision of Intel’s Instruction Extensions Programming Reference , Intel has disclosed a fairly dramatic departure from these “traditional” approaches. Notes on notation: C[i][j] is invariant in the innermost loop, so I refer to the values in the accumulator as elements of the C array.

Cache 40

Cache C++ Latency Hardware 40