Re: Prepared statements considered harmful

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Prepared statements considered harmful
Дата
Msg-id 20060831172945.GF27851@svana.org
обсуждение исходный текст
Ответ на Re: Prepared statements considered harmful  (Lukas Kahwe Smith <smith@pooteeweet.org>)
Список pgsql-hackers
On Thu, Aug 31, 2006 at 06:34:45PM +0200, Lukas Kahwe Smith wrote:
> BTW: PDO has gotten a switch to force client side placeholder
> replacement in favor of using server side prepared statements due to the
> fact that prepared statements side-step the MySQL query cache.

Perl DBD:Pg also has a switch to force one way or the other.

However (as has been stated already) people are confusing prepared
statements with out-of-line parameters. Even DBI uses the phrase
"prepare" for setting up statements, whereas this doesn't actually
require server-side prepare, all it needs is out-of-line parameters.

I see from the source that DBD::Pg does use PQexecParams() sometimes so
maybe it does support out-of-line parameters...

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

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

Предыдущее
От: "Jaime Casanova"
Дата:
Сообщение: updatable views and default values
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Prepared statements considered harmful