stored procedures and dynamic queries
| От | Ivan Sergio Borgonovo |
|---|---|
| Тема | stored procedures and dynamic queries |
| Дата | |
| Msg-id | 20071203185148.0ee09b31@webthatworks.it обсуждение исходный текст |
| Ответы |
Re: stored procedures and dynamic queries
|
| Список | pgsql-general |
Any general rule about dynamically generated queries in stored
procedures vs. performances?
I was going to write stuff as simple as
create or replace function EditQty(int, int, int, varchar(10))
returns boolean as
'
declare
_uid alias for $1;
_aid alias for $2;
_qty alias for $3;
_table alias $4;
_modified timestamp;
begin
_table := 'shop_commerce_basket' || _table
_modified := now();
update _table
set qty=_qty,
modified=_modified
where uid=_uid and aid=_aid;
if not found then
insert into _table (uid, aid, qty)
values(_uid,_aid,_qty);
end if;
end;
' language plpgsql;
Is it going to perform worse than with a static table name?
Where can I find some clue about the effects of similar decisions?
thx
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
В списке pgsql-general по дате отправления: