article thumbnail

HammerDB v4.8 New Features : Viewing your Benchmark results with the HammerDB Web Service

HammerDB

Copy Code Copied Use a different Browser hammerdb>jobs disable 1 Disabling jobs repository, restart HammerDB to take effect and in the GUI use the Jobs Disabled/Enabled option. in in the DATA directory, set this as follows: Copy Code Copied Use a different Browser <commandline> <sqlite_db>/opt/HammerDB-4.8/DATA/hammer.db</sqlite_db>

article thumbnail

How to build HammerDB from source

HammerDB

If you are not already familiar with the programming languages that HammerDB uses, then this earlier post serves as an ideal introduction to what makes up the highest performing GIL free database benchmarking application. The database installation must include both the include and lib directories. BAWT by Paul Obermeier. linux-glibc2.12-x86_64/bin.

C++ 113
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Why Tcl is 700% faster than Python for database benchmarking

HammerDB

Python is a popular programming language, especially for beginners, and consequently we see it occurring in places where it just shouldn’t be used, such as database benchmarking. We use stored procedures because, as the introductory post shows, using single SQL statements turns our database benchmark into a network test).

article thumbnail

HammerDB v4.7 New Features Pt 2: Example CLI Scripts

HammerDB

When you list the HammerDB directory you can now see a directory called “scripts” This directory contains CLI scripts to build, run, delete and query TPROC-C and TPROC-H workloads against all databases. Copy Code Copied Use a different Browser ~/HammerDB-4.7$ Copy Code Copied Use a different Browser ~/HammerDB-4.7/scripts/tcl/maria/tprocc$

C++ 83
article thumbnail

How to deploy HammerDB CLI fast with Docker

HammerDB

The TPC publishes an official Docker image on Docker Hub to enable the rapid deployment and testing of databases with HammerDB. This image includes example scripts to build schemas and test your databases with a single command. hammerdb>librarycheck Checking database library for Oracle Success. Database Configuration.

C++ 62
article thumbnail

HammerDB v4.6 New Features Pt2: Jobs Interface

HammerDB

For example on Windows an example of opening a new database. Copyright (C) 2003-2022 Steve Shaw Type "help" for a list of commands Initialized new SQLite on-disk database C:/Users/Hdb/AppData/Local/Temp/hammer.DB If disabled, the SQLite repository database is not opened, and it is not possible to query any jobs related data.

article thumbnail

HammerDB v4.6 New Features Pt1: Python CLI Interface

HammerDB

Copyright (C) 2003-2022 Steve Shaw. Copyright (C) 2003-2022 Steve Shaw. You should already be aware that due to the Python GIL impacting multithreading performance it is not possible to drive a high-performance database workload directly from Python. Why Tcl is 700% faster than Python for database benchmarking.