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: jkstill <jkstill_at_gmail.com>
Date: 22 May 2007 11:49:32 -0700
Message-ID: <1179859772.208353.16520@y18g2000prd.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.

Really? That's pretty funny.

I would suggest that you have never done any serious performance tuning.
Network traffic is a huge concern.

> If there is a lot of computation
> logic in stored procedure, PL/SQL being an interpreted language may
> run slower.

It can be compiled. And you are missing the point. Received on Tue May 22 2007 - 13:49:32 CDT

Original text of this message

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