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 |
|
|
•