Hi
I have a stored procedure which takes two arguments (agr1, Arg2)
and updates ColumnY with Agr1 in 10 tables where column X=arg2.
But both the input values are looked up in 2 diffrent tables(one lookup with 130 rows and the other with (832250) and then passed to the Stored Procedure.
There are total 2300 rows in the input file which are passed as arguements.
But my concern is it is taking too much time for the SP to finish.
Its taking more than 1 and half hour.
Is it because it's updating many tables at a time? I dont find any other reason as the job is very simple.
Can I improve the performance by changing the settings for the hashed files?
Please suggest me.
Stored Procedure
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Stored Procedure
The problem as you describe it is not in DataStage. You need to find ways to make the SP go faster. For example, can the updates be coded to operate in parallel rather than consecutively?mahi_mahi wrote:But my concern is it is taking too much time for the SP to finish. Its taking more than 1 and half hour.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.