Procedure Vs Pakage [message #287411] |
Wed, 12 December 2007 03:25 |
ORAGENASHOK
Messages: 240 Registered: June 2006 Location: Chennai
|
Senior Member |
|
|
Its one of the interview question
Which one is faster and why procedure or package?
|
|
|
|
|
Re: Procedure Vs Pakage [message #287417 is a reply to message #287413] |
Wed, 12 December 2007 03:45 |
ORAGENASHOK
Messages: 240 Registered: June 2006 Location: Chennai
|
Senior Member |
|
|
According to me procedure is the fast
When we incorporate two procedure with same name but different in number of parameters in a package the execution time may differ i am not having practical knoweledge for the above.
If any one having correct me Maaher?.
|
|
|
|
Re: Procedure Vs Pakage [message #287436 is a reply to message #287411] |
Wed, 12 December 2007 04:24 |
|
The Link
Quote: | performance issue April 28, 2005 - 4pm US/Eastern Bookmark | Bottom | TopReviewer: Christine Guo from Virginia
I agree using package instead of stand alone stored procs. But are there any performance difference
between the two?
I worked with a query returning over 40 million records. There are two functions in this query.
When I tried to put the functions into a package, the performance slowed down dramatically. The
query calling a function returns half million rows in less then 1 minute, and the query calling a
function inside a package returns the half million rows in 6 minutes.
What might be the problem?
BTW, I also noticed that if I put an exception block in the function, it slows down the performance
a lot as well.
Your input would be greatly appreciated.
Followup April 28, 2005 - 4pm US/Eastern:
not that I don't believe you but...
set up a simple example, don't need your tables, just need to understand the difference between
your two implementations.
|
Kiran.
[Updated on: Wed, 12 December 2007 04:29] by Moderator Report message to a moderator
|
|
|
|
|
|
Re: Procedure Vs Pakage [message #287469 is a reply to message #287455] |
Wed, 12 December 2007 05:40 |
|
Michel Cadot
Messages: 68718 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Sorry, changed "code" tags to "quote" tags, I should have precised it.
Rationale: this is a quote (not code) and "code" block does not fold the lines and so they were very long ones.
Regards
Michel
[Updated on: Wed, 12 December 2007 05:41] Report message to a moderator
|
|
|
|