Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Do you use PL/SQL

Re: Do you use PL/SQL

From: joel garry <joel-garry_at_home.com>
Date: 21 May 2007 17:21:04 -0700
Message-ID: <1179793264.211960.68580@b40g2000prd.googlegroups.com>


On May 20, 1:08 pm, zigzag..._at_yahoo.com wrote:

>

> Performance advantage because of network traffic reduction are over
> blown. When you write a stored procedure, only part of the code
> involving network traffic may be accessing information from database
> and writing information to database. If there is a lot of computation
> logic in stored procedure, PL/SQL being an interpreted language may
> run slower. So writing lot of PL/SQL code does not necessarily improve

Bzzzzt! See http://download-west.oracle.com/docs/cd/B19306_01/appdev.102/b14261/tuning.htm#i48528 (free registration is required to read the docs, which you should).

(and in my previous post where I said I agree with previous posts, note that was in cdom, where I hadn't seen zigzag's posts yet)

jg

--
@home.com is bogus.
http://www.kpmg.co.uk/pubs/ProfileofaFraudsterSurvey(web).pdf
Received on Mon May 21 2007 - 19:21:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US