[GENERAL] query is wery slow with _t() function

Hi, I made function: CREATE FUNCTION _t(varchar,integer) RETURNS varchar AS ' DECLARE str ALIAS FOR $1; lang ALIAS FOR $2; value varchar; BEGIN SELECT t.txt INTO value FROM sys_txt t INNER JOIN sys_txt_code c ON c.id = t.code_id WHERE ''#''||c.code||''#'' = str AND t.lang_id = lang;

Re: [GENERAL] query is wery slow with _t() function

Margusja wrote: Hi, I made function: CREATE FUNCTION _t(varchar,integer) RETURNS varchar AS ' DECLARE str ALIAS FOR $1; lang ALIAS FOR $2; value varchar; BEGIN SELECT t.txt INTO value FROM sys_txt t INNER JOIN sys_txt_code c ON c.id = t.code_id WHERE ''#''||c.code||''#'' = str AND