Re: Are there still performance benefits of stored procedures?

Yes it avoids round trips. In terms of processing "in the database" it has
always been better.  There have been other optmizations in terms of Bulk
Processing beginning with 9i.

Hemant K Chitale
http://hemantoracledba.blogspot.com
sent from my smartphone

On Nov 10, 2010 3:22 PM, "RP Khare" <passionate_programmer@xxxxxxxxxxx>
wrote:

 Stored procedures provide business-logic safety, reduces application code
and business-logic is easy to maintain. But are there any performance
benefits?


...........
Rohit.

Other related posts: