Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 07 Nov 2006 @ 18:31:25 GMT


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


Subj:   Re: Data extract from Teradata
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, November 07, 2006 12:54 -->

In Response state, the answer set has already been generated as a spool file and is being sent back to the client. Negligible processing occurs to fetch blocks from that spool as needed. Impact on the system is in two main areas:

Network interface(s) may be very busy sending data; you may want to separate this bulk data traffic from other queries and responses (different physical adapters, maybe different subnet / node / switch). Be sure you have tuned your client settings to transfer 64K data blocks rather than the default 8K.

Disk space occupied by spool file is not released until the transmission is complete (typically not an issue, but once in a while it's a consideration).



     
  <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