Teradata Stored Procedure Help

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Fan

Teradata Stored Procedure Help

Same Teradata Stored Procedure calling in different web services at same time will
screw up performace hiting Teradata Server multiple times.
Is there aant way to Improve Performance?

3 REPLIES
Senior Apprentice

Re: Teradata Stored Procedure Help

This is probably due to the way the logic within the SP is written (e.g. WRITE LOCK on table level?), without details it's hard to tell.

Fan

Re: Teradata Stored Procedure Help

Thanks Dnoeth. As we are also planning to use Row lock for view which are called in the SP.

Will let you know if I see still that issue occuring.

 

Regards,

Senior Apprentice

Re: Teradata Stored Procedure Help

It depends on the view definition what happens when you apply a Row Lock on a view. 

If there's a Lock Table within it it will apply this.