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

Copyright (C) 2003-2023 Steve Shaw Type "help" for a list of commands Initialized SQLite on-disk database /home/steve/HammerDB-4.7/TMP/hammer.DB using existing tables (188,416 KB) SETTING CONFIGURATION Database set to MariaDB Benchmark set to TPC-C for MariaDB. /scripts/tcl/maria/tprocc/maria_tprocc.sh TMP/hammer.DB TMP/hammer.DB

C++ 83
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

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 MariaDB) starting as process 4483. Copyright (C) 2003-2022 Steve Shaw. Benchmark set to TPC-C for MariaDB. Copyright (C) 2003-2022 Steve Shaw. Benchmark set to TPC-C for MariaDB.

C++ 62
article thumbnail

Supercomputing Predictions: Custom CPUs, CXL3.0, and Petalith Architectures

Adrian Cockcroft

Here’s some predictions I’m making: Jack Dongarra’s efforts to highlight the low efficiency of the HPCG benchmark as an issue will influence the next generation of supercomputer architectures to optimize for sparse matrix computations. I presented a keynote for Sun at Supercomputing 2003 in Phoenix Arizona and included the slide shown below.

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:Timing test period of 1 in minutes Vuser 2:RUNNING Vuser 2:Initializing xtprof time profiler Vuser 2:Processing 10000000 transactions with output suppressed. Why Tcl is 700% faster than Python for database benchmarking. >hammerdbcli py.

article thumbnail

HammerDB v4.1 New Features Pt3: Step Workloads

HammerDB

Copyright (C) 2003-2021 Steve Shaw Type "help" for a list of commands HammerDB CLI v4.1 Copyright (C) 2003-2021 Steve Shaw Type "help" for a list of commands Starting 3 replica HammerDB instance Starting 4 replica HammerDB instance Doing wait to connnect. Vuser 3:RUNNING Vuser 3:Processing 10000000 transactions with output suppressed.

article thumbnail

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

Adrian Cockcroft

Another big jump, but now it was my job to run benchmarks in the lab, and write white papers that explained the new products to the world, as they were launched. 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.

Tuning 52