Re: Oracle Stored Procedure Performance??

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/06/27
Message-ID: <962170891.93.0.pluto.d4ee154e@news.demon.nl>#1/1

Handling the load on the client would involve handling outside the database, so include extra network traffic.
IMO, whatever you can do in a select you should do in a select and what you can do in pl/sql on the server on the server you should do on the server. A pl/sql is compiled to pseudo-code, when properly designed (using packaged cursors, and bind variables everywhere) it should always outperform any client implementation.

Hth,

Sybrand Bakker, Oracle DBA

"newsiyal" <anilsiyalNOanSPAM_at_yahoo.com.invalid> wrote in message news:27584256.db40dc97_at_usw-ex0103-023.remarq.com...
> Hi,
> I would like some advice from DBAs or people who have
> implemented high volume systems. Is it better to use Oracle
> stored procedures or not to get optimum performance in a high
> volume system or is better to handle the load on the client side
> (web servers).
> We are not concerned about portability being an issue.
>
> Thanks.
>
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>
Received on Tue Jun 27 2000 - 00:00:00 CDT