From Melissa Data Wiki
Jump to navigation Jump to search

← SSIS:Profiler

Service Speed

What kinds of speeds/throughput can the Profiler component do?

Different analysis features directly affect component performance. Options with data aggregation and sort analysis have a high impact on speed of the component.

The following are the average speeds for 1 Thread across different combinations of Actions selected:

Action Enabled if checked
Sort Analysis X X X X X X X X
MatchUp Analysis X X X X X X X X
Rightfielder Analysis X X X X X X X X
Data Aggregation X X X X X X X X
Results (records/min) 105,000 115,000 100,000 46,800 105,000 81,000 280 91,000 47,100 34,000 80,500 1,100 310 33,333 130