 |
 |
Archives of the TeradataForum
Message Posted: Wed, 17 Dec 2003 @ 15:19:50 GMT
| 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
| |
