[ June 2012 revision ]
Server 1: Intel Core 2 Quad CPU 2.4GHz, 6Gb RAM
Server 2: Intel Core 2 Duo CPU 2.2GHz, 2Gb RAM
Client: Intel Core 2 Duo CPU 3.2GHz, 8Gb RAM
| Test Description | Default mode | Differences only | Performance mode |
|---|---|---|---|
| Test #1 Client with local SQL Server 2008 2 tables with 5,000,000 rows, 3 integer columns about 5% differences |
83 356.59 rows/sec |
83 561.59 rows/sec |
114 365,17 rows/sec |
| Test #2 Client with local SQL Server 2008 2 tables with 5,000,000 rows, 3 integer columns 100% differences |
335 694.74 rows/sec |
347 995.62 rows/sec |
421 194.59 rows/sec |
| Test #3 Client local SQL Server 2008 Server 2 with SQL Server 2005 1 Gbit LAN 2 tables with about 1,000,000 rows, 3 integer columns about 5% differences |
34 834.85 rows/sec |
39 879.82 rows/sec |
46 612.44 rows/sec |
| Test #4 Client local SQL Server 2008 Server 2 with SQL Server 2005 1 Gbit LAN 2 tables with about 1,000,000 rows, 3 integer columns 100% differences |
80 166.36 rows/sec |
79 726.13 rows/sec |
88 051.02 rows/sec |