Remove c
article thumbnail

HammerDB MySQL and MariaDB Best Practice for Performance and Scalability

HammerDB

This post complements the previous best practice guides this time with the focus on MySQL and MariaDB and achieving top levels of performance with the HammerDB MySQL TPC-C test. SELECT DISTINCT c from sbtest where id between ? order by c. SELECT c from sbtest where id=? Copyright (C) 2003-2018 Steve Shaw.

article thumbnail

HammerDB Best Practice for PostgreSQL Performance and Scalability

HammerDB

This post gives a HOWTO guide on system configuration for achieving top levels of performance with the HammerDB PostgreSQL TPC-C test. maximum transition latency: Cannot determine or is not supported. Initially it is best leave all of these states enabled. Latency: 0. Copyright (C) 2003-2018 Steve Shaw.

article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

The caching of data pages and grouping of log records helps remove much, if not all, of the command latency associated with a write operation. Then ​​ write C ​​ obtains ​​ 01 ​​ and so on.

Servers 40