Archives of the TeradataForum
Message Posted: Tue, 10 Apr 2007 @ 12:59:34 GMT
Insert/Select also works at the block level--the recent changes mentioned also handle USI/NUSI maintenance (and rollback) at the block level.
Fastload only populates empty tables which is much faster. Even here, Insert/Select to an empty table is faster even than just the Fastload apply phase excluding acquisition.
For both Multiload and i/s, a key factor is the block hit rate.
Some recent tests Ive seen comparing i/s with Multiload application phase assuming 10 hits per block measured:
16,752 rows/second/node for i/s, 7901 for Multiload.
12,169 rows/second/node for i/s with a NUSI (100 rows/value), 5162 for Multiload.
Another set on prior hardware generation using 5 hits/block:
6,378 rows/second/node for i/s, 5306 for Multiload.
5,222 rows/second/node for i/s with a NUSI (100 rows/value), 2600 for Multiload.
Insert/select also avoids the client/database resource consumption of FastExport (spool + 2 redistributions) and Multiload acquisition phase.
These were standalone tests with 100 byte rows and presumably other differences from your case.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|