Re: Are there still performance benefits of stored procedures?
- From: Hemant K Chitale <hemantkchitale@xxxxxxxxx>
- To: passionate_programmer@xxxxxxxxxxx
- Date: Wed, 10 Nov 2010 16:23:44 +0800
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:
