Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 25 Apr 2002 @ 16:53:58 GMT


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


Subj:   ODBC performance
 
From:   Anomy Anom

<-- Anonymously Posted: Thursday, April 25, 2002 12:47 -->

Are any sites using NCR's ODBC to bring back thousands of rows to the desktop? We have found that this process is very slow. We attempted to bump up the ODBC MaxRespSize option in order to specify a larger size for the Teradata response buffers (the max value is 65477 for V2R3 and above), but when we monitor the tcpip packets via NetMon, it appears that the largest tcpip packet size we can get is only about 1488. Does anyone know what sort of limitation we might be running into? We assume there must be some limiting factor on the client or on the lan or on the database, but maybe someone can give us a list of things to check, assuming that someone has already gone through this exercise. TIA.



     
  <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: 27 Dec 2016