Overhead of Pl/Perl ?

Поиск
Список
Период
Сортировка
От Jean-Denis Girard
Тема Overhead of Pl/Perl ?
Дата
Msg-id 39593E78.F113B0A6@esoft.pf
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Peter Mount
Дата:
Сообщение: RE: still confuse; no suitable driver
Следующее
От: Dnesbitt@encryptix.com
Дата:
Сообщение: JDBC Driver support for SQLException.getSQLState()