Softshare Delta Benchmarks
Computer/Software:
Dell Optiplex 745
Intel Core 2 4300 (1.8 GHz)
3 GB RAM
Microsoft Vista Business 32-bit
Test Data:
| EDI |
1000 EDI 850 transactions version 4010, in 1 ISA Envelope, total of 6064 line items, data size 692,224 bytes |
| Data File |
1000 Orders in a single data file with 2 record types, total of 6064 line items, data size 593,920 bytes |
| XML |
1000 XML Transactions, total of 6064 line items, data size 1,110,016 bytes |
| Database |
1000 Order entries in Microsoft SQL server 2005, 1000 header and 6064 detail records |
Test Conditions:
Benchmark testing was conducted with as little as possible running on the system, and test results were monitored using logging placed in the maps. Maps logged start time, a “split time” for each 1000 orders processed, and a final translation time. Because benchmarks were tracked using this logging method, map “load” time is not included in the benchmark results.
Benchmark Figures
All figures below are for Softshare Delta in test mode.
Scenario: EDI 850 to DATA FILE
| System |
Avg Time (Sec) |
Docs/Sec |
Bytes/Sec |
% Improv |
| Delta 4.1 |
9.950 |
100.503 |
69,570.25 |
|
| Delta 5.0 |
9.450 |
105.820 |
73,251.22 |
5.03% |
Scenario: DATA FILE to EDI 850
| System |
Avg Time (Sec) |
Docs/Sec |
Bytes/Sec |
% Improv |
| Delta 4.1 |
5.900 |
169.492 |
100,664.41 |
|
| Delta 5.0 |
4.350 |
229.885 |
136,533.33 |
26.27% |
Scenario: EDI 850 to EDI 855 (using EDI Bulk Mapping in Delta 5.0)*
| System |
Avg Time (Sec) |
Docs/Sec |
Bytes/Sec |
% Improv |
| Delta 4.1 |
26.800 |
37.313 |
25,829.25 |
|
| Delta 5.0 |
10.950 |
91.324 |
63,216.80 |
59.14% |
*Bulk mapping is a new feature offered in Softshare Delta 5.0 to consolidate multiple EDI transactions into a single envelope
Scenario: EDI 850 to XML
| System |
Avg Time (Sec) |
Docs/Sec |
Bytes/Sec |
% Improv |
| Delta 4.1 |
14.050 |
71.174 |
49,268.61 |
|
| Delta 5.0 |
11.650 |
85.837 |
59,418.37 |
17.08% |
Scenario: EDI 850 to MS SQL Server
| System |
Avg Time (Sec) |
Docs/Sec |
Bytes/Sec |
% Improv |
| SQL Insert (control map) |
| Delta 4.1 |
31.150 |
32.103 |
22,222.28 |
|
| Delta 5.0 |
25.400 |
39.370 |
27,252.91 |
18.46% |
| OLE DB Model |
| Delta 4.1 |
221.000 |
4.525 |
3,132.24 |
|
| Delta 5.0 |
175.000 |
5.714 |
3,955.57 |
20.81% |
| Parameterized Model |
| Delta 5.0 |
49.350 |
20.263 |
14,026.83 |
New for
Delta 5.0! |
Scenario: XML to DATA FILE
| System |
Avg Time (Sec) |
Docs/Sec |
Bytes/Sec |
% Improv |
| Delta 4.1 |
8.050 |
124.224 |
137,890.19 |
|
| Delta 5.0 |
5.850 |
170.940 |
189,746.32 |
27.33% |
Scenario: XML to EDI 850
| System |
Avg Time (Sec) |
Docs/Sec |
Bytes/Sec |
% Improv |
| Delta 4.1 |
7.000 |
142.857 |
158,573.71 |
|
| Delta 5.0 |
5.350 |
186.916 |
207,479.63 |
23.57% |
Scenario: XML to DATABASE (SQL Server)
| System |
Avg Time (Sec) |
Docs/Sec |
Bytes/Sec |
% Improv |
| SQL Insert (control map) |
| Delta 4.1 |
13.150 |
76.046 |
84,411.86 |
|
| Delta 5.0 |
9.650 |
103.627 |
115,027.56 |
26.62% |
| OLE DB Model |
| Delta 4.1 |
180.500 |
5.540 |
6,149.67 |
|
| Delta 5.0 |
176.500 |
5.666 |
6,289.04 |
2.22% |
| Parameterized Model |
| Delta 5.0 |
15.100 |
66.225 |
73,510.99 |
New for
Delta 5.0! |
Scenario: DATA FILE to XML
| System |
Avg Time (Sec) |
Docs/Sec |
Bytes/Sec |
% Improv |
| Delta 4.1 |
4.300 |
232.558 |
138,120.93 |
|
| Delta 5.0 |
3.950 |
253.165 |
150,359.49 |
8.14% |
|
