Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL vs C Performance
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.
>
Received on Sun Jun 06 1999 - 03:26:18 CDT