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?
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.
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.
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.