Re: Speed of different procedural language

> On Sun, Dec 18, 2005 at 01:10:21AM -0000, Ben Trewern wrote:
> > I know I should be writing these in C but that's a bit beyond me. I
was
> > going to try PL/Python or PL/Perl or even PL/Ruby. Has anyone any
idea
> > which language is fastest, or is the data access going to swamp the
> overhead
> > of small functions?
>
> I'm not sure if it's what you ask for, but there _is_ a clear
difference
> between the procedural languages -- I've had a 10x speed increase from
> rewriting PL/PgSQL stuff into PL/Perl, for instance. I'm not sure
which
> ones
> would be faster, though -- I believe Ruby is slower than Perl or
Python
> generally, but I don't know how it all works out in a PL/* setting.

So far, I use plpgsql for everything...queries being first class and
all...I don't have any performance problems with it. I have cut the
occasional C routine, but for flexibility not for speed.

PL/Perl routines cannot directly execute each other, meaning you can't
pass high level objects between them like refcursors. YMMV

Since most database apps are bound by the server one way or another I
would imagine you should be choosing a language on reasons other than
performance.

Maybe Ben you could provide an example of what you are trying to do that
is not fast enough?

Merlin