SSIS 6 Million Rows in 30 Seconds using standard laptop
Settings while Loading data unto heap
1) Enterprise Database Engine is faster than BI Database Engine on my laptop (I really don't know why).
Time: 52.8s
Rows Per Seconds: 113k
2) Commit Size = 0
Time: 40.6s
Rows Per Second: 147k
3) Packet size = 32767
Time: 38.2s
Rows Per Second: 155k
4) Compression = Row
Time: 34.2s
Rows Per Second: 175k
5) Balance Data Distributor = 2 outputs (more than 2 is slower)
Time: 29.3s
Rows Per Second: 204k
Some of you might be thinking it is fast because it is not first run and it cached data? Well after complete machine restart with best config it took 32.1 seconds.
Time: 52.8s
Rows Per Seconds: 113k
2) Commit Size = 0
Time: 40.6s
Rows Per Second: 147k
3) Packet size = 32767
Time: 38.2s
Rows Per Second: 155k
4) Compression = Row
Time: 34.2s
Rows Per Second: 175k
5) Balance Data Distributor = 2 outputs (more than 2 is slower)
Time: 29.3s
Rows Per Second: 204k
Some of you might be thinking it is fast because it is not first run and it cached data? Well after complete machine restart with best config it took 32.1 seconds.
