Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 18 Dec 2003 @ 12:56:09 GMT

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

Subj:   Re: Tearadata SP and ASP
From:   Chris Coffing

Another thought on Store Procedures and ASP...

I have experienced that the SP is returning 3 times when executed in ASP. You may want to check how much data is being returned and determine if the data is being replicated multiple times. This may be the reason the SP takes so much longer from ASP.

We just fixed this with our ASP code by enabling our application to overwrite the result set. We have small amounts of data coming back.

This is not happening when we execute straight SQL for tables, views etc... Just SP...

Chris Coffing
Senior Vice President
Coffing Data Warehousing

  <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: 23 Jun 2019