Home » SQL & PL/SQL » SQL & PL/SQL » Performance issue OUT parameter
icon1.gif  Performance issue OUT parameter [message #248407] Thu, 28 June 2007 22:38 Go to next message
sibgat
Messages: 45
Registered: November 2006
Location: Chennai
Member

Hi,
in a recent interview i have been asked to tell about the performance issue if the procedure has two out parameters, it can do anything in side the procedure...
May i know if there is any performance issue/bottleneck if we have two out parameters in a procedure...
He didn't say anything about the body of the procedure..

Thanks in advance
Sib
Re: Performance issue OUT parameter [message #248415 is a reply to message #248407] Thu, 28 June 2007 23:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No one I'm aware of.

Regards
Michel
Re: Performance issue OUT parameter [message #248422 is a reply to message #248415] Fri, 29 June 2007 00:40 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
I'm also not aware of any performance issues using more than one out parameter..

So, why did you not ask the interviewer what HE thought the reason might be?
Re: Performance issue OUT parameter [message #248543 is a reply to message #248422] Fri, 29 June 2007 08:10 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Oh man, is anyone else sick to death of these little tin Jesuses (apologies to the devout Christians out there) who discover something obscure and interesting last week and ask it in an interview this week to prove they're cleverer than the applicant?

@sibgat, I wouldn't worry about missing that job, that guy would've driven you nuts in about three weeks.

Theoretically (and I'm guessing here), the initial values of OUT parameters might be pushed onto a stack prior to calling the proc and popped off upon return. If you passed in a record of two scalars instead of two separate scalars, then that might result in one less operation.... maybe.... But then you have to consider the cost of building the record in the first place. I could imagine this saving a second or two over a few billion cycles (perhaps).

Ross Leishman
Re: Performance issue OUT parameter [message #248792 is a reply to message #248543] Mon, 02 July 2007 00:53 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
I thought the OP might have completely misunderstood the actual question, which might have been 'What is the disadvantage of adding an out parameter to a function' (as in its first out-parameter)
Re: Performance issue OUT parameter [message #248799 is a reply to message #248792] Mon, 02 July 2007 01:14 Go to previous messageGo to next message
sibgat
Messages: 45
Registered: November 2006
Location: Chennai
Member

No Frank,
What ever i posted was the intended question.
Regards
Sib
Re: Performance issue OUT parameter [message #248825 is a reply to message #248799] Mon, 02 July 2007 04:14 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Ah, ok.
Previous Topic: Function need tuning
Next Topic: for real time information.
Goto Forum:
  


Current Time: Mon Dec 05 18:50:50 CST 2016

Total time taken to generate the page: 0.08523 seconds