MIME-Version: 1.0
References: <291EA3FA-F9FA-4D31-98D1-5CA87749C850@bentley.com>
In-Reply-To: <291EA3FA-F9FA-4D31-98D1-5CA87749C850@bentley.com>
From: "Inoue,Hiroshi" <hinoue205@gmail.com>
Date: Mon, 23 Aug 2021 11:50:35 +0900
Message-ID: 
 <CAFGcedVrkSHznw_SRS5bFymu6NXjdmafZdh48QR+9P971kB=RQ@mail.gmail.com>
Subject: Re: Enabling connection pooling by default
To: Vadim Presniak - Consultant <Vadim.Presniak@bentley.com>
Cc: "pgsql-odbc@postgresql.org" <pgsql-odbc@postgresql.org>,
 Andrius Docius <Andrius.Docius@bentley.com>,
	Zilvinas Susinskas <Zilvinas.Susinskas@bentley.com>
Content-Type: multipart/alternative; boundary="0000000000009f6a7405ca31159f"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFGcedVrkSHznw_SRS5bFymu6NXjdmafZdh48QR%2B9P971kB%3DRQ%40mail.gmail.com>
Precedence: bulk

--0000000000009f6a7405ca31159f
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi Vadim,

I would take care of this patch.

regards,
Hiroshi Inoue

2021=E5=B9=B48=E6=9C=8820=E6=97=A5(=E9=87=91) 20:14 Vadim Presniak - Consul=
tant <Vadim.Presniak@bentley.com
>:

> Hello,
>
>
>
> We had been investigating why our application works dramatically slower
> with Postgre SQL DB than MS SQL Server and found that the main reason was
> related to the fact that CPTimeout option is not set for psqlOdbc driver,
> however this option is set by default to 60 for Microsoft ODBC drivers.
> We=E2=80=99ve done simple patch with changes for psqlOdbc driver installe=
r to
> enable this option during driver installation.
> (0001-CPTimeout-option-set-to-60-for-odbc-driver-by-defaul.patch)  Is it
> possible to push this change in master branch?
>
>
>
> This topic was discussed in 2008 (
> https://www.postgresql.org/message-id/F613CCFA0B7146A38D24394E8F29C66C%40=
andrusnotebook),
> but I could not find final decision for this topic.
>
>
>
> Regards,
>
> Vadim Presniak
>
>
>
> ------------------------------
>
>
> This email, including any attachments, may contain confidential and/or
> proprietary information intended only for the use of the recipient. If yo=
u
> are not the intended recipient, any distribution, copying, or use of this
> email or its attachments is prohibited. If you received this email in
> error, please reply to the sender immediately and delete this message and
> any copies.
>
> *Bentley Systems has taken all reasonable steps to ensure that this
> communication is free from viruses, data corruption, and unauthorized
> alteration. Bentley Systems does not accept liability for any damages tha=
t
> may be incurred as a result of this or any communication by email*
>
>

--0000000000009f6a7405ca31159f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi Vadim,<div><br></div><div>I would take care of this pat=
ch.</div><div><br></div><div>regards,</div><div>Hiroshi Inoue</div></div><b=
r><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">2021=E5=
=B9=B48=E6=9C=8820=E6=97=A5(=E9=87=91) 20:14 Vadim Presniak - Consultant &l=
t;<a href=3D"mailto:Vadim.Presniak@bentley.com">Vadim.Presniak@bentley.com<=
/a>&gt;:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px=
 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">


<div lang=3D"en-RU" style=3D"overflow-wrap: break-word;">
<div class=3D"gmail-m_-5883388131352995075WordSection1">
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:black">Hello,</s=
pan><span style=3D"color:black"><u></u><u></u></span></p>
<p class=3D"MsoNormal" style=3D"font-variant-caps:normal;text-align:start;w=
ord-spacing:0px">
<span lang=3D"EN-US" style=3D"color:black">=C2=A0</span><span style=3D"colo=
r:black"><u></u><u></u></span></p>
<p class=3D"MsoNormal" style=3D"font-variant-caps:normal;text-align:start;w=
ord-spacing:0px">
<span lang=3D"EN-US" style=3D"color:black">We had been investigating why ou=
r application works dramatically slower with Postgre SQL DB than MS SQL Ser=
ver and found that the main reason was related to the fact that CPTimeout o=
ption is not set for psqlOdbc driver,
 however this option is set by default to 60 for Microsoft ODBC drivers. We=
=E2=80=99ve done simple patch with changes for psqlOdbc driver installer to=
 enable this option during driver installation. (0001-CPTimeout-option-set-=
to-60-for-odbc-driver-by-defaul.patch) =C2=A0Is
 it possible to push this change in master branch?</span><span style=3D"col=
or:black"><u></u><u></u></span></p>
<p class=3D"MsoNormal" style=3D"font-variant-caps:normal;text-align:start;w=
ord-spacing:0px">
<span lang=3D"EN-US" style=3D"color:black">=C2=A0</span><span style=3D"colo=
r:black"><u></u><u></u></span></p>
<p class=3D"MsoNormal" style=3D"font-variant-caps:normal;text-align:start;w=
ord-spacing:0px">
<span lang=3D"EN-US" style=3D"color:black">This topic was discussed in 2008=
 (<a href=3D"https://www.postgresql.org/message-id/F613CCFA0B7146A38D24394E=
8F29C66C%40andrusnotebook" target=3D"_blank">https://www.postgresql.org/mes=
sage-id/F613CCFA0B7146A38D24394E8F29C66C%40andrusnotebook</a>),
 but I could not find final decision for this topic.</span><span style=3D"c=
olor:black"><u></u><u></u></span></p>
<p class=3D"MsoNormal" style=3D"font-variant-caps:normal;text-align:start;w=
ord-spacing:0px">
<span lang=3D"EN-US" style=3D"color:black">=C2=A0</span><span style=3D"colo=
r:black"><u></u><u></u></span></p>
<p class=3D"MsoNormal" style=3D"font-variant-caps:normal;text-align:start;w=
ord-spacing:0px">
<span lang=3D"EN-US" style=3D"color:black">Regards,</span><span style=3D"co=
lor:black"><u></u><u></u></span></p>
<p class=3D"MsoNormal" style=3D"font-variant-caps:normal;text-align:start;w=
ord-spacing:0px">
<span lang=3D"EN-US" style=3D"color:black">Vadim Presniak</span><span style=
=3D"color:black"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<br>
<hr>
<br>
<br>
<p>This email, including any attachments, may contain confidential and/or p=
roprietary information intended only for the use of the recipient. If you a=
re not the intended recipient, any distribution, copying, or use of this em=
ail or its attachments is prohibited.
 If you received this email in error, please reply to the sender immediatel=
y and delete this message and any copies.</p>
<p><i>Bentley Systems has taken all reasonable steps to ensure that this co=
mmunication is free from viruses, data corruption, and unauthorized alterat=
ion. Bentley Systems does not accept liability for any damages that may be =
incurred as a result of this or
 any communication by email</i></p>
<br>
<p><img src=3D"https://cdn2.webdamdb.com/310th_sm_UnR3pO7k0ir0.jpg?16161763=
29" width=3D"100"></p>
</div>

</blockquote></div>

--0000000000009f6a7405ca31159f--