Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 05 Jan 2007 @ 16:48:25 GMT


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


Subj:   Re: Performance of Teradata SQL Assistant 7.1
 
From:   Dempsey, Mike

When you say 'Insert' do you mean with Import mode, or just simple Insert queries?

If Import, have you checked the settings of the Import buffer sizes to ensure that you are not over allocating the buffer sizes.

You should also verify that you have the latest TTU8.1 versions of SQL Assistant and ODBC:

     SQLA 7.1.0.8
     ODBC 3.5.0.9

These are available from the patch server.

Also note that SQLA 6.2 (with ODBC 3.3) would be using ASCII while 7.1 (with ODBC 3.5) will be using a Unicode interface.

This should not generally have a major effect on performance, but it may have some effect.


Mike Dempsey
Teradata Client Tools



     
  <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