Test Database Generator Performance Reports

[ June 2015 revision ]

Project: Single table with 4 integer columns, 5 000 000 rows. Performance mode.
System: Intel Core i5-2500 CPU 3.3GHz, 16Gb RAM
Test 1: SQL Server 2008 x64
Test 2: PostgreSQL 9.3 x64
Test 3: MySQL 5.5
Test 4: Oracle 11g
Test 5: Firebird 2.1
Test 6: Microsoft Access 2003
Test 7: SQLite 3.8

Performance report, Test 1

Data mode	Target	Insert mode	Transaction size	Output file (Mb)	Performance (Rows/sec)
Append	Local server	bulk	1 000	-	47 053
Append	Local server	bulk	5 000	-	87 165
Append	Local server	bulk	10 000	-	96 854
Append	Local server	bulk	25 000	-	102 961
Append	Local server	default	1 000	-	11 031
File only	SQL script	-	1 000	403	192 968
File only	Text file	-	1 000	190	209 722
File only	XML document	-	1 000	785	57 864
File only	JSON document	-	1 000	354	31 778
Scramble	Local server	default	1 000	-	6 515
Append	Remote server	default	1 000	-	4 548

Performance report, Test 2

Data mode	Target	Insert mode	Transaction size	Output file (Mb)	Performance (Rows/sec)
Append	Local server	default	1 000	-	5 823
Scramble	Local server	default	1 000	-	4 871
Append	Remote server	default	1 000	-	1 817

Performance report, Test 3

Data mode	Target	Insert mode	Transaction size	Output file (Mb)	Performance (Rows/sec)
Append	Local server	default	1 000	-	17 158
Scramble	Local server	default	1 000	-	14 316

Performance report, Test 4

Data mode	Target	Insert mode	Transaction size	Output file (Mb)	Performance (Rows/sec)
Append	Local server	default	1 000	-	2 495
Scramble	Local server	default	1 000	-	2 245
Append	Remote server	default	1 000	-	1 395

Performance report, Test 5

Data mode	Target	Insert mode	Transaction size	Output file (Mb)	Performance (Rows/sec)
Append	Local server	default	500	-	7 438

Performance report, Test 6

Data mode	Target	Insert mode	Transaction size	Output file (Mb)	Performance (Rows/sec)
Append	Local data file	default	500	-	5 245

Performance report, Test 7

Data mode	Target	Insert mode	Transaction size	Output file (Mb)	Performance (Rows/sec)
Append	Local data file	default	500	-	9 210