Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 14 Jul 2016 @ 11:33:34 GMT


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


Subj:   Re: ODBC throughput from Teradata to Microstrategy
 
From:   Dave Wellman

Hi,

(Disclaimer - most of my programming is with CLIv2 and not ODBC but this may still help).

I've had a fair amount of success with CLIv2 programs by using 'two response buffers = Yes' (I think default is 'No'), this essentially gets the CLIv2 s/w to request the next buffer of data from the dbms whilst the application is processing the existing buffer.

From looking at the ODBC docs it looks like the 'enablereadahead' option is the equivalent option. It also says that this option is set to 'Yes' by default - but it may be worth checking that is what is being used.


Cheers,

Dave

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



     
  <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: 24 Jul 2020