Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 13 Apr 2007 @ 15:19:43 GMT


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


Subj:   Re: Merging large volumes of data into large history tables
 
From:   william.gregg

Dan - any secondary indices on the MultiLoaded tables?

Below is captured from a prior note from Dan Linstedt.

By the way, a note about performance on Teradata and getting data IN fast... I recently had the pleasure/opportunity to work on a large multi- node system, all I can say is MLOAD speeds were approaching 400,000 rows per second for 1.2k byte row sizes, to an empty table. FastLoad was approaching 600,000 rows per second to the same table.


Rgrds,

Bill Gregg
Teradata Team
Thomson Healthcare



     
  <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