Re: PL/SQL vs C Performance

When I tried to access huge (several MB's) amounts of data when doing 'fetches' via Pro*C cursors, execution time was several magnitudes faster than the same operation done in PL/SQL. PL/SQL cannot scale like compiled Pro*C, but it has other advantages as seamless datatype exchange across stack variables.

-M

Mladen Gogala wrote:

> 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 Tue Jun 08 1999 - 12:26:06 CDT