Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 17 Dec 2003 @ 15:19:50 GMT


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


Subj:   Re: Tearadata SP and ASP
 
From:   Dieter Noeth

Vikram Singh wrote:

  I am getting a problem where in calling Teradata SP takes no time when run from queryman or BTEQ. But when the same is called through ASP application using Teradata OLE DB Driver, it process with huge time.  


What do you mean by time? Elapsed wall-clock time or Teradata CPU time?


  Can anyone help me to know why its taking so much time.  


Looks like a ASP problem, so this is out of my scope of knowledge....


  Will it help if I use BTEQ scripts in place of Teradata SP as Teradata SP has got some performance issues specially when used with cursors in it.  


If you can replace the SP with a macro, there'll be a difference, when it's called repeatedly. Macros are generally faster than SPs, but you can put more complex code into a SP.

Regarding cursors, every DBMS has performance problems with cursors, because cursors are processed serially, whereas a DBMS is optimized for set operations.

On Teradata it's especially bad, because a SP runs on one node only using a single CPU.


Dieter



     
  <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: 15 Jun 2023