Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Connectivity Tests
From:   rmhsmd

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020