DTM Data Scrubber Performance Report

[ December 2012 revision ]

Environment: Server and Client: Intel Core i5-2500 3.30 GHz
Operating system: Windows 7, 64 bit
Database: SQL Server 2008

Table size: 14,000,000 rows
Project type: Verification
Check type: compare with constant

Table size: 14,000,000 rows
Project type: Verification
Check type: value in range

Table size: 5,000,000 rows
Project type: Clearing
Check type: compare with constant with empty action

Table size: 5,000,000 rows
Project type: Clearing
Check type: regular expression with trim action

Test #	Total time, sec	Rules per Second	Report Type	Matches, %
1	95.42	146 712.08	HTML	90
1	70.84	197 628.46	No report	90
2	371.60	37 674.62	HTML	50
2	86.67	161 526.66	No report	50
3	573.52	8 718.02	HTML
3	275.33	18 159.83	No report
4	1 270.73	3 934.75	HTML
4	1 182.22	4 229.32	No report