Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL vs C Performance
Jonathan Lewis wrote:
>
> You also have to consider the fact that until 8.0
> PL/SQL cannot do array fetches, whereas C can.
> The performance impact will vary with platforms,
> environment etc. but I used to find a factor of
> 3 to 4 between C arrays abd PL/SQL loops for
> shifting data on a 'quiet' system.
>
> You've already had the most important suggestion though -
> > Sometimes you have to do both to test for performance.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
> John Seitz wrote in message <3759C7AE.3B2DDC4C_at_pobox.com>...
> >Well the real speed is that the Database doesn't have to transfer the data
> >across the network. C code is much faster at doing calculations, but if
> those
> >calcs require huge amounts of data from the DB then PL/SQL will more then
> likely
> >be faster.
> >
Concorde is much faster then my Hyundai Elantra but they are not used
for the same thing. The same applies to C and PL/SQL. C is faster then
PL/SQL
but these languages are not used for the same purpose.
--
Mladen Gogala
Received on Sun Jun 06 1999 - 17:16:18 CDT