SQL Performance

APRIL 14, 2021

It has excellent performance, and there’s quite a lot that you can learn from it. Evaluating earlier solutions, one of the important factors in getting good performance was the ability to employ batch processing. Here are the performance numbers that I got in my test: CPU time = 10032 ms, elapsed time = 10025 ms.

Servers 112

Servers C++ Testing Code 112

Sutter's Mill

FEBRUARY 17, 2020

C++ “move” semantics are simple, and unchanged since C++11. Move: What it is, and how to use it In C++, copying or moving from an object a to an object b sets b to a ’s original value. This post is an attempt to shed light on that situation. That’s it for what advanced users need to know. Yes, but don’t.

C++ 98

C++ Testing Design Programming 98

Testlodge

AUGUST 9, 2023

Steps to Performing Basis Path Testing The first step is to create a control flow graph for a specified code section. When there are multiple options for a decision, each decision outcome should be exercised before moving on to the next decision. Let’s say we want to perform basis path testing on a basic block of code.

Testing 75

Testing Software Software C++ 75

All Things Distributed

NOVEMBER 15, 2010

This incredible power is available for anyone to use in the usual pay-as-you-go model, removing the investment barrier that has kept many organizations from adopting GPUs for their workloads even though they knew there would be significant performance benefit. with a peak performance of 4.701 PetaFLOPS.

AWS 125

AWS Programming Latency Architecture 125

Percona

DECEMBER 5, 2023

The scenario Service considerations In this exercise, we wanted to perform a major version upgrade from PostgreSQL v12.16 The 1-2-3 Steps Per the title of this post, the next is the list of steps to perform the PITR, then pg_upgrade to v15.4, Start the new instance to perform the PITR with LSN Start the new PostgreSQL instance.

Database 103

Database Traffic C++ Servers 103

HammerDB

JULY 16, 2021

One of the most important concepts in analysing database performance is that of understanding scalability. When a system ‘scales’ it is able to deliver higher levels of performance proportional to the system resources available to it. reaches peak performance at 1006469 NOPM at 122 Virtual Users, with MySQL 5.7

Virtualization 58

Virtualization Performance C++ Database 58

Sutter's Mill

JUNE 3, 2021

Briefly, what is the difference among: (a) undefined behavior Undefined behavior is what happens when your program tries to do something whose meaning is not defined at all in the C++ standard language or library (illegal code and/or data). You’ll get some valid result, but you won’t know what the result is until your code looks at it.

C++ 73

C++ Programming Lambda Code 73

Sutter's Mill

JANUARY 11, 2021

And asserted conditions only evaluated if they’re enabled, so any side effects won’t happen when they’re not enabled; they might sometimes perform local side effects, such as to do logging or allocate memory, but the program should never rely on them happening or not happening. Assertions are only about finding bugs, not doing program work.

C++ 81

C++ Programming Code Testing 81

HammerDB

APRIL 19, 2023

Predicting application performance is a difficult art, but an important one when choosing the target deployment environment. In this blog, we aim to call out some key considerations when trying to assess MySQL performance for your application. We will not concern ourselves with the raw throughput of workload.

Performance 55

Performance Benchmarking Cache Storage 55

Smashing Magazine

DECEMBER 2, 2021

Good ol’ PerfPlanet is back for another season with all things speed and web performance. Anyone is welcome to contribute to the calendar , so do feel free to reach out with a topic or tool you’re passionate about, or a technique you’d like to teach and tell the web performance community about. C# Advent Calendar. Rock on! ??.

Design 120

Design Development Programming Website 120

SQL Performance

JULY 1, 2021

t2 ( id bigint IDENTITY PRIMARY KEY , msg ntext ) ; Now, let's try to perform online operations on the tables: ALTER TABLE dbo. An online operation cannot be performed for index 'PK__t2__3213E83FEEA1E0AD' because the index contains column 'msg' of data type text, ntext, image or FILESTREAM. name , [ Column ] = c.

C++ 58

C++ Database Servers Performance 58

Speed Curve

MARCH 5, 2023

How can I demonstrate the business value of performance to people in my organization?" If you've ever asked yourself any of these questions, then you could find the answers in identifying and understanding the performance plateau for your site. What is the "performance plateau"? The concept of the performance plateau isn't new.

Performance 52

Performance C++ Metrics Ecommerce 52

Sutter's Mill

JANUARY 25, 2021

Example 1(a)’s min <= max is at this other end of the scale: It’s so dirt cheap to check that it’s unlikely we’ll ever have a performance reason to disable it. [2] Because we realistically can’t write and exercise them all, though, we could be observing a secondary effect from a bug that happened earlier. Dos Reis, J. Meredith, N.

C++ 63

C++ Programming Cache Testing 63

Percona

AUGUST 30, 2023

This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. For example, I want to connect to the database to perform some bulk data loading and manipulation (ETL), and I don’t want to wait for any WAL writing. But this can be specified at the subsequent levels also.

Database 120

Database Servers Open Source Tuning 120

Brendan Gregg

DECEMBER 21, 2019

For my AWS re:Invent talk on BPF Performance Analysis at Netflix, I began with a demo of "BPF superpowers" (aka eBPF). Embedded C. # # Tone generation from: [link] # # 29-Apr-2019 Brendan Gregg Created this. My [BPF Performance Tools] book has plenty of examples. strength: -46 strength: -46 strength: -45 strength: -45 [.]

C++ 52

C++ Education Java AWS 52

Brendan Gregg

DECEMBER 21, 2019

For my AWS re:Invent talk on BPF Performance Analysis at Netflix, I began with a demo of "BPF superpowers" (aka eBPF). Embedded C. # # Tone generation from: [link] # # 29-Apr-2019 Brendan Gregg Created this. My [BPF Performance Tools] book has plenty of examples. usr/bin/python # # iwlstrength.py

C++ 52

C++ Education Java AWS 52

O'Reilly

DECEMBER 12, 2023

This ruling in itself raises many questions: how much creativity is needed, and is that the same kind of creativity that an artist exercises with a paintbrush? Given a search string, it’s simple for Google to perform the search, take the top few results, and then send them to a language model for summarization. We have provenance.

Artificial Intelligence 134

Artificial Intelligence Media Google Processing 134

Particular Software

MARCH 28, 2022

Saga analyzers Sagas have a powerful API, but it’s limited by the confines of C#. You can create a class that is a lousy saga but is still perfectly valid C# code. So the newest version of our testing framework now includes tools to perform saga scenario testing , which are more expressive than testing sagas with standard unit tests.

Development 52

Development C++ Virtualization Metrics 52

Tasktop

FEBRUARY 1, 2021

A Value Stream Architecture (VSA) diagram can provide that visual cue: A Value Stream Architecture exercise maps the flow of value-creating and -protecting software delivery work across your toolchain that underpins your product value stream. Measuring the Flow. Get Software Delivery trends and insights in your inbox. Subscribe now.-.

Logistics 52

Logistics Metrics Architecture Software 52

The Agile Manager

MAY 31, 2021

A value-generative investment is an exercise in deploying risk capital through IT in the pursuit of extraordinary benefit that yields competitive advantage. The risks in a legacy modernization investment are entirely to do with execution of the investment itself, not how well the investment performs post-production.

C++ 52

C++ Efficiency Systems Technology 52

The Morning Paper

DECEMBER 8, 2019

At the start of November I was privileged to attend HPTS (the High Performance Transaction Systems) conference in Asilomar. With NVM we have both an opportunity to avoid serialisation overheads, and also an obligation since these overheads would be intolerable compared to the performance of NVM. Early performance results.

Hardware 56

Hardware Programming Media Storage 56

Tasktop

OCTOBER 29, 2020

It’s the gym membership that forces you to exercise. There is just the hard transformation work that needs to be delegated to the product value streams themselves: Start by baselining: VSM tools measure the value streams’ current performance in terms of time-to-market, velocity and efficiency. . Next, examine your bottlenecks.

Storage 52

Storage Speed C++ DevOps 52

The Agile Manager

AUGUST 31, 2021

Each person is responsible for the outcome because team performance is measured on collective output (specifically, stories in production) as opposed to the sum of individual output (tasks completed by individuals). One person who does a substandard job affects the performance of the entire team.

Metrics 52

Metrics Design Engineering C++ 52

ScaleOut Software

AUGUST 20, 2020

They make use of standard object-oriented concepts and languages (such as C#, Java, and JavaScript). This exercises the model’s code and surfaces issues and exceptions, which can be readily examined and resolved in a controlled environment. Real-time digital twins are designed to be easy to develop and modify.

Cloud 52

Cloud Development Analytics Azure 52

ScaleOut Software

AUGUST 20, 2020

They make use of standard object-oriented concepts and languages (such as C#, Java, and JavaScript). This exercises the model’s code and surfaces issues and exceptions, which can be readily examined and resolved in a controlled environment. Real-time digital twins are designed to be easy to develop and modify.

Cloud 52

Cloud Development Analytics Azure 52

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

The Agile Manager

APRIL 26, 2010

A leaned-out IT organization capitalizing a significant proportion of its discretionary spend is highly susceptible to a perfect storm of (a) SG&A contraction, (b) IT project write-off, and (c) suspended IT investments. Capitalizing development of IT assets is an exercise in funding salaries and contractor costs out of CapEx budgets.

Government 49

Government Efficiency C++ Software 49

SQL Performance

SEPTEMBER 25, 2020

a AS /* comment here because -- chaos */ int = 5 , @b AS varchar ( 64 ) = 'AS = /* BEGIN @a, int = 7 */ ' 'blat' '' , @c AS int = -- 12. We have the object and schema name together without having to perform any additional iteration or concatenation. Really hard. CreateProcedureStatement. ProcedureReference. SchemaObjectName.

Code 42

Code C++ Database Servers 42

CSS Wizardry

NOVEMBER 3, 2020

A couple of years ago, my first few days on a new web performance project were always slow going. Unless a client hires you to specifically improve the performance of one page, you’ll need a broad view of the whole site or application. All through no fault of the client or the project, but through huge flaws in my own approach.

Speed 328

Speed Ecommerce Metrics Analytics 328

O'Reilly

FEBRUARY 11, 2025

OReilly author Andrew Stellman recommends several exercises for learning to use AI effectively. Unit tests are a useful exercise because testing logic is usually simple; its easy to see if the generated code is incorrect. AI doesnt mean that you dont need to know your toolsincluding the dark corners of your programming languages.

Programming 94

Programming Code Software Software 94

SQL Performance

JUNE 10, 2020

That is, does SQL Server perform a substitution process whereby it converts the original nested code into one query that goes directly against the base tables? Customers AS C WHERE EXISTS ( SELECT * FROM Sales. custid = C. Customers AS C LEFT OUTER JOIN Sales. Orders AS O ON C. custid , C. custid , C.

C++ 109

C++ Database Servers Code 109

SQL Performance

JUNE 10, 2020

That is, does SQL Server perform a substitution process whereby it converts the original nested code into one query that goes directly against the base tables? Customers AS C WHERE EXISTS ( SELECT * FROM Sales. custid = C. Customers AS C LEFT OUTER JOIN Sales. Orders AS O ON C. custid , C. custid , C.

C++ 93

C++ Database Servers Code 93

John McCalpin

JANUARY 22, 2018

The exercise seemed simple enough — just fix one item in the Colfax code and we should be finished. For 64-bit floating-point data, the 512-bit Fused Multiply-Add (FMA) instructions performs 16 floating-point operations (8 adds and 8 multiplies). There was no deep goal — just a desire to see the maximum GFLOPS in action.

Latency 40

Latency Hardware Code Testing 40

John McCalpin

JANUARY 22, 2018

There was no deep goal — just a desire to see the maximum GFLOPS in action. The exercise seemed simple enough — just fix one item in the Colfax code and we should be finished. For 64-bit floating-point data, the 512-bit Fused Multiply-Add (FMA) instructions performs 16 floating-point operations (8 adds and 8 multiplies).

Latency 40

Latency Hardware Code Testing 40