Overhead of Pl/Perl ? - Mailing list pgsql-interfaces

From Jean-Denis Girard
Subject Overhead of Pl/Perl ?
Date
Msg-id 39593E78.F113B0A6@esoft.pf
Whole thread Raw
List pgsql-interfaces
I would like to know what is the overhead of using Perl versus C in
terms of memory
consumption, speed...

I'm storing usernames / encrypted passords in a table and wrote this
ridiculous Pl/Perl
function:   CREATE FUNCTION "crypt" (text,text )   RETURNS bool AS 'return (crypt($_[0],$_[1]) eq $_[1]) ? 1:0;'
LANGUAGE'plperl'
 

in order to do things like:   select * from users where name='foo' and crypt(passwd, 'bar')

This is the only stored procedure I use in the database.
Is there any real life benefit in rewriting the function in C, and
loosing the simplicity of Perl ?

Thanks,
Jean-Denis Girard




pgsql-interfaces by date:

Previous
From: Peter Mount
Date:
Subject: RE: still confuse; no suitable driver
Next
From: Dnesbitt@encryptix.com
Date:
Subject: JDBC Driver support for SQLException.getSQLState()