Archives of the TeradataForum

Message Posted: Tue, 07 Feb 2001 @ 01:21:11 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Don't have the facts but as a comparison we do a single session CLI insert of 400+K rows in about 45 minutes on a 5200 (that's about what 150 rows/sec; rowsize about 120bytes. ran also with 5 NUSI's on table in 90 minutes. We run MLOADS of about 3M rows on the 4 node 5200 in about 18 minutes; adding 1 NUSI added about 33% to elapsed; same row size & 64KB blksize. Obviously there is an area where either is acceptable; so it mostly depends on the batch administration, data availability for querying, and more complex index usage.

Attached is four slides (a little dated but good reference). In your example the size of the configuration would be a consideration. If I had to guess I would use CLI inserts (perhaps TPUMP for multiple sessions and the batch functionality of MLOAD) to keep the table available and the fact that you are most likely updating a very low % of DB (data blocks).

<>

	<Prev	Next>		<<First	<Prev	Next>	Last>>