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. Therefore, before we attempt to measure our database performance, we should know the system or cloud instance to be tested in detail. We will not concern ourselves with the raw throughput of workload.

Performance 54

Performance Benchmarking Cache Storage 54

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 99

Database Servers Open Source Tuning 99

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 99

Artificial Intelligence Media Google Processing 99

ScaleOut Software

AUGUST 20, 2020

Simplifying the Development Process with Mock Environments. Development is fast and straightforward using standard object-oriented techniques, and the test/debug cycle is kept short by making use of a mock environment running on the developer’s workstation. Debugging with a Mock Environment.

Cloud 52

Cloud Development Analytics Azure 52

ScaleOut Software

AUGUST 20, 2020

Simplifying the Development Process with Mock Environments. Development is fast and straightforward using standard object-oriented techniques, and the test/debug cycle is kept short by making use of a mock environment running on the developer’s workstation. Debugging with a Mock Environment.

Cloud 52

Cloud Development Analytics Azure 52

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

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

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

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

512 byte response (use database context xxxxxx, default language xxxxxxx, test size xxxxx). – -c the control file. The following is a simple query for looking at the rate of login and logouts the test is accomplishing. The following is a simple query for looking at the rate of login and logouts the test is accomplishing.

Servers 40

Servers Network Database Systems 40