Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Insert vs. Multiload
From:   James Judge

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023