Shell Programming and Scripting

Hi Otheus
I did the same and the result obtained is
I find the stored procedures takes less time in dev compared to stored procedures that run Prod .

I think that as there is low load in dev , it updates the tables fast compared to Prod database .

Please let whether am I right or anyother factors that I have to check ?

~ Sakthifire

I think that's it. It's expected that database procedures take longer in a production environment than in a dev environment. You should not see major time differences in the other places in the script.

Yes Otheus . You are right . I find the script which calls all the stored procedures , takes 80 % of the total time when compared with other scripts .When compared the dev and Prod time log , I find the total time taken in dev is almost half the value in prod . In both the logs the time taken is major by the script which has stored procedures calling .

~Sakthifire