Archives of the TeradataForum
Message Posted: Thu, 18 Dec 2003 @ 12:56:09 GMT
| 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
www.coffingdw.com
| 
