Prepared queries vs Non-prepared

Поиск
Список
Период
Сортировка
От Denis Gasparin
Тема Prepared queries vs Non-prepared
Дата
Msg-id 460A2788.5010806@edistar.com
обсуждение исходный текст
Ответы Re: Prepared queries vs Non-prepared  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
Hi!
I am testing the PHP PDO library versus the old style PHP postgres
functions.

I noted that PDO library declare and prepare every statement. I mean:

$s = $db->query("select * from test where field=1");

is equivalent to

$s = $db->prepare("select * from test where field=?");
$s->execute(array('1'));

I logged the queries sent to the database and i saw that they are the
same (apart obviously the parameter):

PREPARE pdo_pgsql_stmt_b7a71234 AS select * from test where field=1
<BIND>
EXECUTE <unnamed>  [PREPARE:  select * from test where field=1]

PREPARE pdo_pgsql_stmt_b7a713b0 AS select * from test where field=$1
<BIND>
EXECUTE <unnamed>  [PREPARE:  select * from test where field=$1]


Speaking about postgresql performance...
would not it be more efficient executing directly the query in the first
case ($db->query) than
preparing a statement without parameters and then executing it?

Thank you in advance,
Denis


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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: tweaks for write-intensive dbs ?
Следующее
От: "Dmitry Koterov"
Дата:
Сообщение: Re: Strange behaviour under heavy load