Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 07 Mar 2005 @ 16:14:11 GMT


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


Subj:   Re: FastExport performance vs. Fastload
 
From:   cas.apanowicz

Hi,

The data transfer is way below the connection capacity. The physical throughput is 1Gb/s (or 1000Mb/sec) and my average fexport is 2000 blocks per minute. Even assuming the max block size 64k it is way below the capacity.

As fare as disk - I tried two types of processing:

1) Writing to SAN attachment made up of small disks of 36G.

2) Writing to named pipes to avoid I/O.


In case 2) I created named pipe in C++ program. This program was reading data as it comes from fexport and did not write anywhere just discard, to avoid any I/O on the disks.

The result was the same.


Cas



     
  <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