Swingbench 2.8

I’m pleased to announce the release of Swingbench 2.8. It includes

• A new html front end to run and review benchmark runs
• New tool to render results with the ability to compare runs
• Fixes to TPC-C
• Fixes and new drivers.

Clearly the standout feature of this release is the the new HTML frontend allowing you to run swingbench on or close to the server. Similar to a web application. There will be plenty of improvements to the the web front end in the comming months. Lets quickly go through some of these changes

Web Front End

You can launch the web front end by using the command

./sbweb

By default it will run off port 8080 but you have the option to change it at launch by simply specifying the port number. See the help defintion below.

./sbweb --help
Usage: WebServer [port] [--config <file>] [--debug]
  port               Port to listen on (default 8080)
  --config, -c FILE  Preload this configuration XML into memory for editing/starting
  --debug            Enable verbose (FINE) logging to stdout

Open a browser and visit http://localhost:8080 to access the web front end. You should see the following

Before running a workload, you must first select a config file from the “Workload” drop down. This will load a memory resident version of the file. This can be modified in the UI or by clicking on the “Edit Config” button. It’s worth noting that any changes made to this file will not be saved to disk.

On pressing the “Start Benchmark” button, the user’s threads will start running against the target database. When the user presses the stop button or the timers expire, the user session threads will stop running transactions. A short time after this, a window will appear showing the results which have also been stored in the database. You can preview previous runs by clicking on the “Past benchmark runs”. This is retrieve a list of previous runs. By clicking on anyone of these runs, you will bring up a report showing some of the runs’ key metrics.

Formatting Result Files

Whilst XML is simple to parse by a computer it is not necessarily ideal for humans. In the bin/winbin directory you’ll find three utilities that will convert XML files or the JSON held in the database into text, pdfs or csv files. These utilities are called results2pdf, results2txt and compareresults2pdf.

• results2pdf - Takes a single results file and converts it into a pdf version. With the results being presented in tables and graphs. At some stage this will be deprecated.
• results2txt - Takes a single or multiple results file or ids from results stored in the database and converts them into a series of text tables. If multiple results are given (file or database) they are compared with one another
• compareresults2pdf - Takes a single or multiple results file or ids from results stored in the database and converts them into series of tables and graphs. If multiple results are given (file or database) they are compared with one another To list previous workloads held in the database use a command similar to

./compareresults2pdf -u soe -p soe -cs //localhost/soe --list

== Available Runs ==
+----+---------------------+--------------------------------------+
| ID | Recording Time      | Recording Name                       |
+----+---------------------+--------------------------------------+
| 41 | 2025-11-07 09:28:00 | "Order Entry (PLSQL) V2" - Charbench |
| 22 | 2025-11-06 15:50:54 | "Order Entry (PLSQL) V2" - Charbench |
| 21 | 2025-11-06 15:50:20 | "Order Entry (PLSQL) V2" - Charbench |
| 1  | 2025-11-06 15:45:35 | "Order Entry (PLSQL) V2" - Web UI    |
+----+---------------------+--------------------------------------+

To compare previous runs run a command similar to

./compareresults2pdf -u soe -p soe -cs //localhost/soe --ids 21,22,41
PDF written to: /Users/dgiles/java/swingbench/swingbench/bin/results_comparison.pdf

Or if you want to generate a pdf report of comparison of results files run a command like

./compareresults2pdf -f results27102024.xml,results27102025.xml,results27102026.xml
PDF written to: /Users/dgiles/java/swingbench/swingbench/bin/results_comparison.pdf

To generate text output you can run a similar command to

./results2txt -f results27102024.xml,results27102025.xml,results27102026.xml

== Overview ==
+----------------+--------------------------+--------------------------+--------------------------+
| Metric         | results27102026.xml (-)  | results27102025.xml (-)  | results27102024.xml (-)  |
+----------------+--------------------------+--------------------------+--------------------------+
| Recording Name | "Order Entry (PLSQL) V2" | "Order Entry (PLSQL) V2" | "Order Entry (PLSQL) V2" |
| Avg TPS        | 1904.5                   | 1920.6                   | 1604.8                   |
| Total Txns     | 38089                    | 38411                    | 32095                    |
| Failed Txns    | 0                        | 0                        | 0                        |
| Run Time       | 0:00:20                  | 0:00:20                  | 0:00:20                  |
| Users          | 120                      | 160                      | 160                      |
| Time Of Run    | 31 Oct 2025, 15:27:29    | 31 Oct 2025, 15:26:45    | 31 Oct 2025, 15:24:56    |
+----------------+--------------------------+--------------------------+--------------------------+

== DML Totals ==
+--------------------+---------------------+---------------------+---------------------+
| DML Metric         | results27102026.xml | results27102025.xml | results27102024.xml |
+--------------------+---------------------+---------------------+---------------------+
| SelectStatements   | 157702              | 158989              | 133047              |

Download

As always you can download the most recent version of the code here

I’ve also added a video that discusses some of these changes. You can view it on my YouTube channel here.

• 2025 4
• 2024 1
• 2023 5
• 2022 8