Archives of the TeradataForum
Message Posted: Thu, 18 Dec 2003 @ 12:56:09 GMT
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...
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|