Hello,
I have small piece of code for testing speed of stored procedures. First
time used its for compare mysql5 and postgresql. One year ago (feb.2004)
was PostgreSQL much faster than mysql5. Now I was surprised. Mysql was
faster. Mysql's developers did some work, but plpgsql is slowly than
before :-(.
I used Linux, 2xP160, 256MB, with zero loading
PostgreSQL 7.4.6 needed 8896 ms
PostgreSQL 8.0.0. rc5 needed 24009 ms
I know so used SP is not clasic, only arithmetic operations, no sql code,
but maybe it can signalize some problems..
CREATE OR REPLACE FUNCTION delitel(int, int) RETURNS int AS '
DECLARE a integer; b integer;
BEGIN a := $1; b := $2; WHILE a <> b LOOP IF a > b THEN a := a - b; ELSE b := b - a; END IF; END LOOP; RETURN a;
END; ' LANGUAGE plpgsql;
Regards
Pavel Stehule
