SQL Performance

APRIL 14, 2021

Evaluating earlier solutions, one of the important factors in getting good performance was the ability to employ batch processing. Let’s examine the plans for two of the earlier solutions that utilized batch processing. But have we exploited it to the maximum extent possible?

C++ 112

C++ Servers Testing Code 112

SQL Performance

JUNE 10, 2020

This month and the next I’m going to cover the physical processing aspects of derived tables. 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? And if so, is there a way to instruct SQL Server to avoid this unnesting process?

C++ 109

C++ Database Servers Code 109

J. Paul Reed

SEPTEMBER 24, 2018

People had such a positive experience and got so much value out of getting more information about their local job markets, I’ve been asked repeatedly to write up the process. I am often asked “How can you even think of doing this exercise?” Whatever they put is fine. Base salary : rounded to the nearest hundred dollars.

DevOps 74

DevOps C++ Google Engineering 74

SQL Performance

JUNE 10, 2020

This month and the next I’m going to cover the physical processing aspects of derived tables. 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? And if so, is there a way to instruct SQL Server to avoid this unnesting process?

C++ 93

C++ Database Servers Code 93

Nick Desaulniers

APRIL 18, 2014

So a whole Babel of computer languages has been created for programmers: FORTRAN, BASIC, COBOL, LISP, Pascal, C, PROLOG, FORTH. This blog is meant for those who don’t know x86-64 assembly, but maybe know a little C, and are curious about code generation. But you never can tell exactly what the compiler is doing. Dan Gohman.

C++ 98

C++ Programming Code Virtualization 98

Percona

DECEMBER 5, 2023

The scenario Service considerations In this exercise, we wanted to perform a major version upgrade from PostgreSQL v12.16 While we’ve contemplated taking a physical backup and conducting PITR , it’s worth noting that PITR can also be executed on the existing replica or delayed replica to expedite the process. and a v15.4.

Database 82

Database Traffic C++ Servers 82

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. A change to such parameters requires the postmaster — the main process of the PostgreSQL — to restart. psql "host=localhost user=postgres options='-c synchronous_commit=off'" psql (14.8)

Database 109

Database Servers Open Source Tuning 109

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? But reading texts has been part of the human learning process as long as reading has existed; and, while we pay to buy books, we don’t pay to learn from them.

Artificial Intelligence 103

Artificial Intelligence Media Google Processing 103

Particular Software

MARCH 28, 2022

With a saga, a business process that would otherwise have been implemented as a clunky batch job 1 can be built in a much more elegant and real-time manner. 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.

Development 52

Development C++ Virtualization Metrics 52

HammerDB

JULY 16, 2021

with the TPROC-C workload on a system with 2 sockets of Intel Xeon 8280L that means we have 28 cores per socket, with 56 physical CPUs and 112 logical CPUs with Hyper-Threading. Plotting these data points enables us to understand the scalability of the database software being tested on that system. and MySQL 8.0.25 and MySQL 8.0.25

Virtualization 58

Virtualization Performance C++ Database 58

ScaleOut Software

AUGUST 20, 2020

Simplifying the Development Process with Mock Environments. The key to meeting these challenges is to process incoming telemetry in the context of unique state information maintained for each individual data source. They make use of standard object-oriented concepts and languages (such as C#, Java, and JavaScript).

Cloud 52

Cloud Development Analytics Azure 52

ScaleOut Software

AUGUST 20, 2020

Simplifying the Development Process with Mock Environments. The key to meeting these challenges is to process incoming telemetry in the context of unique state information maintained for each individual data source. They make use of standard object-oriented concepts and languages (such as C#, Java, and JavaScript).

Cloud 52

Cloud Development Analytics Azure 52

Tasktop

FEBRUARY 1, 2021

In a project organization, this flow is spread across teams, functions, tools, processes and even external parties like vendors. Carving out the relevant pieces for each product is an iterative process. The more this process encroaches on the status quo, the more resistance you will encounter. . Measuring the Flow.

Logistics 52

Logistics Metrics Architecture Software 52

The Agile Manager

NOVEMBER 30, 2020

These can be useful exercises, certainly to the business leaders who’ve got to find their customers or compete against rivals with slimmed down cost structures. Or, suppose that city C imposes putative taxes on companies employing a distributed workforce. It’s not unprecedented.

Airlines 52

Airlines Retail C++ Transportation 52

Speed Curve

MARCH 5, 2023

Site A Site B Site C Site D Observations 1. The plateau emerges surprisingly quickly in some cases For example, Site C's performance plateau starts at 400 milliseconds. For some sites (such as Site C), the difference was as little as 300 milliseconds. That's early! You need to look at your own real user data. (If

Performance 52

Performance C++ Metrics Ecommerce 52

Tasktop

OCTOBER 29, 2020

Beneath the question lies a fear — always legitimate, but especially so in a year of economic distress and highly constrained budgets — that a VSM tool will simply expose what is already known: “Our processes, workflows and tools are a mess. After we’ve cleaned up our act and matured our processes, we’ll finally be ready for a VSM tool.” .

Storage 52

Storage Speed C++ DevOps 52

HammerDB

APRIL 19, 2023

Instead, focus on understanding what the workloads exercise to help us determine how to best use them to aid our performance assessment. In the context of MySQL performance evaluation, it simulates a typical online transaction processing (OLTP) workload on your MySQL database. and 8.0.32 HammerDB 4.5 Concurrency at 80 VU’s 1.00

Performance 55

Performance Benchmarking Cache Storage 55

The Agile Manager

AUGUST 31, 2021

If we accept the fact that Agile is a value system and not a set of mechanical processes, it stands to reason that there must be something different about the norms and behaviors of Agile managers vis-a-vis traditional managers. Create and adapt the mechanical processes and social systems through which the team gets things done.

Metrics 52

Metrics Design Engineering C++ 52

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

The Morning Paper

DECEMBER 8, 2019

The eagle-eyed reader will have noticed another feature of this work in that quotation: the aim is to create a global address space that spans nodes and processes. The Twizzler KVS (key-value store) is just 250 lines of C code, and uses one persistent object for the index structure, and a second one for the data. What about security?

Hardware 56

Hardware Programming Media Storage 56

HammerDB

JANUARY 5, 2019

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

Benchmarking 40

Benchmarking Database Social Media Scalability 40

SQL Server According to Bob

FEBRUARY 10, 2019

– -c the control file. I started with a cmd file script exercising the connection path. If the login was in the middle of processing pre-login the ring buffer entry may show time spent in SSL, reads, etc and the disconnect. · The dump suspends the SQL Server process. – -n controls the number of threads.

Servers 40

Servers Network Database Systems 40