Re: Prepared statements [was: Session state per transaction]

Поиск
Список
Период
Сортировка
От Karsten Hilbert
Тема Re: Prepared statements [was: Session state per transaction]
Дата
Msg-id 20120928103341.GA4253@hermes.hilbert.loc
обсуждение исходный текст
Ответ на Prepared statements [was: Session state per transaction]  (Daniele Varrazzo <daniele.varrazzo@gmail.com>)
Ответы Re: Prepared statements [was: Session state per transaction]  (Daniele Varrazzo <daniele.varrazzo@gmail.com>)
Список psycopg
On Fri, Sep 28, 2012 at 02:32:42AM +0100, Daniele Varrazzo wrote:

> I've played a little bit with the idea and made a cursor subclass
> instead: it does everything like a normal cursor, but has a prepare()
> method. If it is called, execute() and executemany() can be called
> without a query, in which case they execute the statement stored (the
> cursor can have only one, but several cursors can be used to prepare
> several statements). If execute*() receive a query too they behave
> like normal cursors

Maybe check the received query string against the already
prepared query string and on match reuse the prepared query ?

Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346


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

Предыдущее
От: Daniele Varrazzo
Дата:
Сообщение: Re: Prepared statements [was: Session state per transaction]
Следующее
От: Daniele Varrazzo
Дата:
Сообщение: Re: Prepared statements [was: Session state per transaction]