DTM Data Generator, test data generator for database testing purposes: performance reports

DTM Data Generator
Realistic data for database testing purposes

• Features • Revision History • On-line Documentation • Press releases • Screenshots • Downloads • SDK • Order

• DTM SQL editor

• DTM Schema Reporter

• DTM Migration Kit

• DTM Data Generator

• DTM Data Editor

• DTM DB Stress

• DTM Data Modeler

• DTM Data Scrubber

• DTM Data Comparer

• DTM Schema Comparer

• DTM Query Reporter

• DTM Schema Inspector

• DTM DB Event

• DTM XML Generator

• DTM Flat File Generator

DTM Data Generator, Professional edition performance report

[ August 2007 revision ]

Server 1: Intel Core 2 Quad CPU 2.4GHz, 2Gb RAM
Server 2: Intel Core 2 Duo CPU 2.2GHz, 2Gb RAM
Client: Intel Pentium M 1.7 GHz, 1Gb RAM
LAN: 100 Mbit, TCP/IP
Test 1: Server 1, Single table with 4 integer columns, SQL server 2005 x64 (5,000,000 rows, performance mode)
Test 2: Server 1, Single table with 4 integer columns, PostgreSQL 8.1 (1,000,000 rows, performance mode)
Test 3: Server 1, Single table with 4 integer columns, MySQL 5 (5,000,000 rows, performance mode)
Test 4: Server 2, Single table with 4 integer columns, Oracle 9 (5,000,000 rows, performance mode)

Performance report, Test 1

Data mode	Target	Insert mode	Transaction size	Output file (Mb)	Performance (Rows/sec)
append	local server	bulk	1000	-	15677
append	local server	bulk	5000	-	20710
append	local server	bulk	10000	-	21789
append	local server	bulk	25000	-	24350
append	local server	default	1000	-	3652
-	SQL script	-	1000	400	81053
-	Text file	-	1000	190	90660
-	XML document	-	1000	780	21788
scramble	local server	default	1000	-	3468
append	remote server	default	1000	-	1510

Performance report, Test 2

Data mode	Target	Insert mode	Transaction size	Output file (Mb)	Performance (Rows/sec)
append	local server	default	1000	-	5795
scramble	local server	default	1000	-	4771
append	remote server	default	1000	-	1617

Performance report, Test 3

Data mode	Target	Insert mode	Transaction size	Output file (Mb)	Performance (Rows/sec)
append	local server	default	1000	-	6591
scramble	local server	default	1000	-	5088

Performance report, Test 4

Data mode	Target	Insert mode	Transaction size	Output file (Mb)	Performance (Rows/sec)
append	local server	default	1000	-	1194
scramble	local server	default	1000	-	1155
append	remote server	default	1000	-	395

Customer Area