Re: Are SPs as Fast as C programs on Oracle?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 4 Mar 2000 11:56:04 +0100
Message-ID: <952167541.18156.0.pluto.d4ee154e@news.demon.nl>

PL/SQL procedures execute on the server, your C calls locally. PL/SQL blocks are processed as one single call, and yes to are compiled to pseudo code.

Hth,

Sybrand Bakker, Oracle DBA

<Sean_at_kewi.net> wrote in message news:894603$ao9$1_at_nnrp1.deja.com...
> Hello,
>
> I am working on a PL/SQL stored procedure that does some moderately
> intensive data manipulation (after making the calls to the dbase).
>
> I am wondering if it is faster to have a C object in Oracle make the
> calls to the database directly and crunch the data appropriately or will
> the PL/SQL procedure run faster?
>
> Or when you compile the PL/SQL procedure, does it write it to
> "optimized" machine code?
>
> Thanks,
> Sean
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Mar 04 2000 - 04:56:04 CST