Archives of the TeradataForum
Message Posted: Fri, 24 Jan 2003 @ 16:45:13 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|