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

>Or when you compile the PL/SQL procedure, does it write it to
> "optimized" machine code?

No, Pl/SQL is a p-code compiler (Like old VB). In other words it is a little faster interpreter.
It is very fast to access and manipulate data, but rather slow for floating point calcs.
It is very easy to write programs with... "Intensive data manipulation" may have very many meanings. You must try your own tests.
Just my 2 cents (after writing 120K lines of Pl/SQL)

Thomas

<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 Thu Feb 24 2000 - 15:52:05 CST