Remove 2003 Remove Benchmarking Remove Code Remove Virtualization
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

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>

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 2: Example CLI Scripts

HammerDB

Copy Code Copied Use a different Browser ~/HammerDB-4.7$ Copy Code Copied Use a different Browser ~/HammerDB-4.7/scripts/tcl/maria/tprocc$ Copy Code Copied Use a different Browser ~/HammerDB-4.7/scripts/tcl/maria/tprocc$ It will create the number of virtual users to the number of CPUs on the system where HammerDB is running.

C++ 83
article thumbnail

How to deploy HammerDB CLI fast with Docker

HammerDB

Copyright (C) 2003-2022 Steve Shaw Type "help" for a list of commands Initialized new SQLite on-disk database /tmp/hammer.DB The image can be found on Docker Hub under the tpcorg account. Docker Pull. On a system with docker installed, use docker pull tpcorg/hammerdb to pull the latest image. Use a different Browser. Use a different Browser.

C++ 62
article thumbnail

HammerDB v4.6 New Features Pt2: Jobs Interface

HammerDB

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 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 Use a different Browser.

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. Copy Code Copied Use a different Browser /home/hammerdb/HammerDB-4.7#./scripts/tcl/postgres/tprocc/pg_tprocc.sh

article thumbnail

HammerDB v4.6 New Features Pt1: Python CLI Interface

HammerDB

Copyright (C) 2003-2022 Steve Shaw. Copyright (C) 2003-2022 Steve Shaw. Vuser 1:1 Active Virtual Users configured Vuser 1:TEST RESULT : System achieved 39945 NOPM from 92893 SQL Server TPM Vuser 1:Gathering timing data from Active Virtual Users. Use a different Browser. $./hammerdbcli hammerdbcli py HammerDB CLI v4.6.