Archives of the TeradataForum

Message Posted: Fri, 24 Jan 2003 @ 16:45:13 GMT

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

Good on the response buffersize settings.

One more BTEQ thing: BTEQ can exploit CLI's 'double buffering' to overlap transit of the next response buffer with consumption of the current one. TTU7.0 BTEQ supports set commands '.set session respbuflen' and '.set session tworespbufs' as alternative to clispb specification.

BTEQ should 'win' the single session tests--even over FastExport since FXP has additional setup time in the query phase to prepare the response for parallel return. The return phase then should be equal if both use double maxsize response buffers.

At some point over the next few weeks I'll try some runs with FXP.

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