Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 16 Nov 2011 @ 09:26:50 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: FastExport Sessions vs performance
From:   Dave Wellman


The 'sessions' specified in FX are only used to transfer the result set back to the client.

Essentially what happens is:

- the select gets run on a single session (just as if you ran it using SQLA or BTEQ) and the answer set is built in a spool file

- the spool file is then split into data blocks

- the data blocks are transferred to the client using multiple sessions

It is this data transfer portion where FX gets it's speed compared to BTEQ (and most other export utilities).



Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023