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

What Adrian Did Next?—?Part 2?—?Sun Microsystems

Adrian Cockcroft

I was mostly coding in C, tuning FORTRAN, and when I needed to do a lot of data analysis of benchmark results used the S-PLUS statistics language, that is the predecessor to R. I also applied Six Sigma to capacity planning and presented this at a conference in 2003. He had it up and running on Wednesday. that a lot of people used.

Tuning 52
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

Note: ​​ Pages that are nev er modified ( never​​ dirtied) remain in the clean state until they are dis c arded at which time the checksum is validated for the constant page. ​​ The following table outlines the virtual protection states. ​​ When the modification latch is acquired.

Servers 40