Benchmark

<< Communication Diagnostics | IBExpert | HK-Software Services Control Center >>

tutorial available

IBExpert Benchmark

How do you measure the performance of your own server or your clients'? Have you ever tried to compare the database speed of your Firebird server with new server hardware? Is a XEON Machine better than an Opteron? What improvements can you expect from fast SAS hard disks, RAID controllers or Enterprise SSDs?

Using the IBExpert Benchmark tool you can generate and compare a reproducible speed index for your Firebird Server hardware. On average, our IFS servers with Firebird are 5 to 10 times faster than the server or virtual machines that our customers have previously used. (This feature is unfortunately not included in the free IBExpert Personal Edition, however you may use our Free IBExpert Benchmark Tool, which allows standard benchmarks to be performed locally.)

Based on a demo database, which is created automatically, the standard benchmark, which is also included in the Free IBExpert Benchmark Tool, runs approximately 8 million operations (individual insert/update/delete/select statements) using 10 simultaneous processes in 2 runs on databases created with different parameters to demonstrate the impact of the physical drive speed.

New to IBExpert version 2020.03.x in all IBExpert Developer Studio customer versions: the extended benchmark uses 50 parallel processes (simulating 50 concurrent users) and the XXL benchmark simulates 250 concurrent users with its 250 simultaneous processes.

XXL Benchmark results using Firebird 3.0 on an i9 ASUS RS300

Remote benchmark tests can be performed on the Firebird 2.5 Superserver, Classic server, Superclassic server or Firebird 3.0 32- or 64-bit, Windows, Linux etc. The Benchmark software is implemented as a 32-bit Windows software, but it can connect to any remote Firebird Installation.

Compare your server's performance to our IFS servers! This simple but effective tool gives you a reference benchmark, based on our recommended IFS Servers.

Our servers will show you a typical Firebird 2.5 Superserver performance of at least 200% for the CPU and at least 200% for the HDD Test with our IFS server series), und using Firebird 3.0 at least 230% for the CPU and at least 500% for the HDD Test. Results under 100% indicate an outdated server performance.

Important: This benchmark gives you a value to compare several hardware or software configurations running the Firebird server. Changing the server to a more powerful hardware might improve the speed by 100%. In addition optimizing your software and database operations can often improve the speed by more than 1000%. Ask sales@ibexpert.biz for further support, for example our remote Support or on-site Workshops.

Benchmark results using Firebird 3.0 on an IFS 2020 Server

The Thread test category (implemented in IBExpert version 2017.01.15) calculates the percentage value for multi-threaded CPU tests with 5000 pages cache result to better see the advantages when using Firebird 3.

If you wish to collect the results for comparision with different hard and software combinations, enter a brief description of the configuration to be tested, along with the recipient email address for the statistic report. Then add the required database connection Information - you need to set a new path for the newly generated database; if you specify the path of an existing database, you will receive a warning message:

Specify the Firebird client, as well as the user name and password (the standard SYSDBA and masterkey). Finally click Start benchmark to run the benchmark test.

IBExpert now creates the demo database, which always follows the same guidelines. It then executes the INITALL procedure in this database. Following this parallel threads are created, which attempt to input further orders into the database. Following the Drive Test, the CPU Test test then is executed.

The results are displayed in the lower window: the drive and the CPU index are percentage index values comparing to our our IFS Server v. 6.0 series, which we rated at the time at 100%.

If you have specified an email address, you will receive the results by mail, with the heading as specified in the Please add a short description of the Firebird server hard- and software field.

To perform the IBExpert Benchmark at your customers and also take advantage of the extended and XXL benchmarks, you can use either the IBExpert Developer Studio customer version or the IBExpert Day Edition. To perform standard benchmarks locally, you may use our Free IBExpert Benchmark Tool.

If you are interested in a free benchmark test, please write to us: sales@ibexpert.biz.

See also:
IBExpert Demo DB

back to top of page
<< Communication Diagnostics | IBExpert | HK-Software Services Control Center >>