emp7 Files

EMP7 is a database benchmark. EMP7 is very simple and can be fully executed in few seconds.
Collected results close forecast DB performances after HW or SW upgrades.
EMP7 scripts are available for Oracle, MySQL, PostgreSQL, Informix, SQLite, JDBC (Grinder), ... 



Most common bootlenecks for database applications are CPU or Storage.

EMP7 is very useful for predicting performances with CPU bound database applications.
If You are migrating a CPU intensive database application to a new server,
You can easly predict perfomance improvements with EMP7.

Few, fast and
easly repeatable tests can be performed on the old and the new server:

results can be linear interpolated to predict application performances.
Multiprocessor, multicore, hyperthreading, virtualization, ... all exotic CPU configurations
can be tested easly
with several increasing looping sessions of EMP7 bechmark.



EMP7 results are very useful for rightsizing Your database server.
For processor licensed software (Oracle, DB2, ...) savings can be very high

Implementation
The bench is based on a table with 14 rows (like the EMP demo table in Oracle).
EMP7 uses a query with 7 self joins that must handle 100 millions rows (14^7 = 105.413.504)
The task is CPU intensive (it uses CPU, cache and memory access)
performing
millions of join and test activities


There are scripts for:
Oracle,
PostgreSQL,
MySQL,
SQLite,
JDBC (Grinder Jython script), DB2

Feedback
Please send Your results to mail AT meo.bogliolo.name
Detailed informations are needed for publishing (CPU, OS, RDBMS, Make/Model, ...)

Very slow devices or impatient DBAs can use a reduced version of this benchmark: EMP6 or EMP5
The patch to create an EMP5/6 is straightforward...

Other benchmarks
EMP7 is useful for CPU bound database applications
For Disk/Storage performances use an other benchmark
For a general reference use standard benchmark (eg. TPC) o an Open Source implementation
For an application benchmark use a test framework (eg. Grinder)


License
Copyright 1996-2011 mail AT meo.bogliolo.name 

This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  
See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA