Re: Prepared statements considered harmful

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: Prepared statements considered harmful
Дата
Msg-id 1157051473.3059.5.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: Prepared statements considered harmful  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
Ühel kenal päeval, N, 2006-08-31 kell 20:01, kirjutas Peter Eisentraut:

> For PL/pgSQL, you simply write a query and all the preparing action 
> happens implicitly.  There is nothing explicit about that interface.
>
> So if users have certain expectations here, they're just making them up.

Or basing them on experience.

I for one would not like it at all if all my queries (select * from
plpgsqlfunc()) just magically become slower by 10-50% 

If there will be an option not to plan/optimise prepared statemants, I
would certainly expect it to be off by default.

-- 
----------------
Hannu Krosing
Database Architect
Skype Technologies OÜ
Akadeemia tee 21 F, Tallinn, 12618, Estonia

Skype me:  callto:hkrosing
Get Skype for free:  http://www.skype.com




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: Prepared statements considered harmful
Следующее
От: "Victor B. Wagner"
Дата:
Сообщение: Re: [PATCHES] Backend SSL configuration enhancement