DTM Data Comparer, data comparison performance report. How fast it works for typical comparions.

DTM Data Comparer
Compare your data easy

• Features • Revision History • On-line Documentation • Press releases • Screenshots • Downloads • 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 Comparer performance report

[ October 2010 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 2.2GHz, 2Gb RAM

Performance report

Test Description	Default mode	Differences only	Performance mode
Test #1 Client with local SQL server 2005 2 tables with about 1,000,000 rows, 3 integer columns about 5% differences	24,578.10 rows/sec	31,516.67 rows/sec	39,465,29 rows/sec
Test #2 Client with local SQL server 2008 2 tables with about 1,000,000 rows, 3 integer columns 100% differences	60,356.59 rows/sec	59,990.64 rows/sec	68,997.41 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	24,834.85 rows/sec	31,879.82 rows/sec	40,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	60,066.36 rows/sec	59,326.43 rows/sec	68,852.42 rows/sec

DTM Data Comparer performance report

Performance report

See also