Re: Extracting SQL from logs in a usable format

Поиск
Список
Период
Сортировка
От Chris Ernst
Тема Re: Extracting SQL from logs in a usable format
Дата
Msg-id 4B2F8527.1030402@esoft.com
обсуждение исходный текст
Ответ на Re: Extracting SQL from logs in a usable format  (Dimitri Fontaine <dfontaine@hi-media.com>)
Ответы Re: Extracting SQL from logs in a usable format  (Dimitri Fontaine <dfontaine@hi-media.com>)
Список pgsql-general
Dimitri Fontaine wrote:
> Le 19 déc. 2009 à 16:20, Chris Ernst a écrit :
>
>> Hmm.. That does look very interesting.  The only thing that concerns me
>> is where it says it supports "Basic Queries (Extended queries not yet
>> supported)".  I'm not sure what is meant by "Extended queries".  Any idea?
>
> I think it refers to the Extended Query support in the frontend / backend protocol, as in the documentation:
>   http://www.postgresql.org/docs/8.4/static/protocol-flow.html#PROTOCOL-FLOW-EXT-QUERY
>
>   The extended query protocol breaks down the above-described simple query protocol into multiple steps. The results
ofpreparatory steps can be re-used multiple times for improved efficiency. Furthermore, additional features are
available,such as the possibility of supplying data values as separate parameters instead of having to insert them
directlyinto a query string 
>
> So that's for parse/bind/execute communications, which are used in prepare/execute and queryParam I think.

Ouch!  You're right.  And that's would be a deal killer for me.  About
90% of the traffic is prepared queries that are run over and over with
different parameters.

    - Chris

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

Предыдущее
От: Durumdara
Дата:
Сообщение: Re: Charset Win1250 on Windows and Ubuntu
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Selecting from table into an array var