Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 06 Feb 2004 @ 22:20:48 GMT


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


Subj:   Re: QueryMan Performance???
 
From:   Mandoda, Hamesh

In the ODBC administrator go to the Tracing tab and ensure that ODBC tracing is turned off. If the button says "Start Tracing Now" then it means it is already turned off and it is another issue. But if it says "Stop Tracing Now" click it and then try your query again.

Out of curiosity - did you try running the same query in BTEQ to see if the response time is the same???

I am using queryman version 5.2 and ODBC for Teradata version 3.0. All of a sudden starting today I experience very huge degradation in the performance only in returning the result set into my answer-window. What used to take few seconds now take hours.. any clues... Please help me out.... Thanks Sankar



     
  <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