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.8 New Features : Viewing your Benchmark results with the HammerDB Web Service

HammerDB

Copyright (C) 2003-2023 Steve Shaw Type "help" for a list of commands Initialized new Jobs on-disk database /opt/HammerDB-4.8/DATA/hammer.db Copyright (C) 2003-2023 Steve Shaw Type "help" for a list of commands Initialized new Jobs on-disk database /opt/HammerDB-4.8/TMP/hammer.DB So for example to change this to hammer.db DATA/hammer.db

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

HammerDB v4.7 New Features Pt 3: Lightweight Docker Images for rapid testing

HammerDB

introduces more lightweight database specific Docker Images, so if you only want to run benchmarks against a specific database you can go from having no benchmarking environment to reviewing your results in as little as 3 commands. How to deploy HammerDB CLI fast with Docker HammerDB v4.7 Copy Code Copied Use a different Browser.

article thumbnail

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

HammerDB

scripts/tcl/maria/tprocc/maria_tprocc_buildschema.tcl echo "+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-" echo "RUN HAMMERDB TEST" echo "+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-"./hammerdbcli If HammerDB is running on a separate system from the database under test then you should modify this value accordingly.

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. Our Linux test system is running a MariaDB 10.10 Our Linux test system is running a MariaDB 10.10

C++ 62
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 build has been tested on x64 Red Hat 8.X The build has been tested on x64 Windows 10 and 11. HammerDB-4.4-Linux.tar.gz

C++ 113
article thumbnail

HammerDB v4.6 New Features Pt1: Python CLI Interface

HammerDB

Copyright (C) 2003-2022 Steve Shaw. Copyright (C) 2003-2022 Steve Shaw. print(z," VU TEST") . print("TEST SEQUENCE COMPLETE"). Vuser 1:Timing test period of 1 in minutes Vuser 2:RUNNING Vuser 2:Initializing xtprof time profiler Vuser 2:Processing 10000000 transactions with output suppressed. >hammerdbcli py.