Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 07 Mar 2005 @ 10:03:48 GMT

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

Subj:   Re: FastExport performance vs. Fastload
From:   Victor Sokovin

  I have dedicated connection between Teradata box and Win2003 server via Gigabit card. I'm, performing simple export SELECT * FROM in fastexport.  

  The effect is that export takes approximately 5 x longer that fastload of the same data to the table.  

What is the disk storage solution on the Win box? How efficient is it? In the worst case scenario you might be writing to just one physical device. That would be a bottleneck that you don't have while FastLoading, where many disk would be spinning at the same time making the load more efficient.

You could conduct a simple test by, say, ftp-ing the same amount of data from the TD machine to the Win box. How much time would that part of the job take?

I second that optimizing the number of sessions could help a lot (not x5, though). Try to use just 4 sessions as both min and max. It is often a good starting point.



  <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: 28 Jun 2020