DBT1 Fast results Report

DBT1 v1.1

This is a Sample Page. The links below do not work, and are provided for illustration only

Transaction Rate and Distribution


interaction	%	avg response time (s)
AC		0.09	0.240
AR		0.09	0.196
BS		4.93	0.385
BC		1.22	0.253
BR		2.60	0.257
CR		3.01	0.000
HO		16.27	0.220
NP		4.94	0.386
OD		0.65	0.237
OI		0.75	0.208
PD		16.95	0.223
SR		19.90	0.213
SU		16.97	0.136
SC		11.61	0.231

109.3 bogotransactions per second
14.7 minute duration
total bogotransactions 96109
error bogotransactions 0


The test runs 14 different queries, refered to as 'interactions' The first block reports the query distribution, which is a weighted random, and the average response time for each query. Average response time greater than one second is very bad.


200 Emulated users 10000 item database 2 processors Think time 1.6 seconds, Calculated Max BT Rate: 250 Kernel: 2.4.18

Here we show the size of the system, the size of the run and the kernel version.
Run Times
---------

Time for datagen 5:19
Time for database creation 2:34
Time for table creation 2:29
Time for index creation 1:14
Time for scripts 0:02
Time for loadproc 0:01
Time for backup database 1:00
Time for DBT run 19:42

We keep a log of elapsed time for each section of the test. Below, we report statistics for the load and run sections of the test.

Run Phase

Results in TXT format

Load Phase

Results in TXT format