Archives of the TeradataForum

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

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

<-- 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>>