First stress test: Pass 6 millions of records from a Flat File, to CSV file.
In this test (with SSIS), the first run was sufficient to document and compare because the times were reasonable, without having to modify the design and SETTINGS to reduce the execution time.
|Objective:||To measure elapsed time reading and writing 6 million rows, from Flat file, to .CSV file, working on local disk.|
|Resources:||Virtual machine with: 2 GB RAM, Integration Services like main process over the virtual plataform. The resources used are anecdotal, today, Any production environment has enough processing power for current and future requirements. The objective here, is to build, to execute and to measure with the same environment (regardless of the limited resources)|
|Design & Run|
|Elapsed time (s)||148 sec.|
|Rows per sec (avg)||
|Summary of log||