MIME-Version: 1.0
References: 
 <CAL4ovZoYjU0NiHg+aYYvzzPChjyYpFGyWt8QwDvkvt91UessZA@mail.gmail.com>
In-Reply-To: 
 <CAL4ovZoYjU0NiHg+aYYvzzPChjyYpFGyWt8QwDvkvt91UessZA@mail.gmail.com>
From: Dave Cramer <davecramer@postgres.rocks>
Date: Mon, 18 Mar 2024 14:49:21 -0400
Message-ID: 
 <CADK3HHK471z_+FXxKL=SonAc8p15aHoqm7XVKsCV5O51y4_HQw@mail.gmail.com>
Subject: Re: PostGres ODBC too slow
To: vedant patel <vedantpatel297@gmail.com>
Cc: pgsql-odbc@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000daa3ef0613f3d12c"
Archived-At: 
 <https://www.postgresql.org/message-id/CADK3HHK471z_%2BFXxKL%3DSonAc8p15aHoqm7XVKsCV5O51y4_HQw%40mail.gmail.com>
Precedence: bulk

--000000000000daa3ef0613f3d12c
Content-Type: text/plain; charset="UTF-8"

Can you explain where/why you think it is too slow ?

Dave Cramer
www.postgres.rocks


On Mon, 18 Mar 2024 at 10:56, vedant patel <vedantpatel297@gmail.com> wrote:

> Hello There,
>
> Recently, we've encountered some performance issues with the ODBC driver
> provided by Postgres. Upon investigation, we noticed that switching from
> the UNICODE to ANSI driver resulted in performance improvements for some
> queries, albeit at the expense of others.
>
> To delve deeper into this matter, I conducted tests using a Python script
> with the psycopg2 library, and the results were significantly better.
> However, to address this issue comprehensively, I've explored alternative
> ODBC drivers available in the market. While some minor improvements were
> observed in a few queries with a different driver, the overall performance
> remains a concern.
>
> Given your extensive experience in this area, I would greatly appreciate
> your insights and recommendations on which ODBC driver would be most
> suitable for our use case. Any advice or suggestions you could offer would
> be immensely helpful in resolving this performance issue.
>
> Let me know in case of any questions or concerns.
>
> Thanks,
>

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

<div dir=3D"ltr">Can you explain where/why you think it is too slow ?<div><=
br clear=3D"all"><div><div dir=3D"ltr" class=3D"gmail_signature" data-smart=
mail=3D"gmail_signature"><div dir=3D"ltr">Dave Cramer<div>www.postgres.rock=
s</div></div></div></div><br></div></div><br><div class=3D"gmail_quote"><di=
v dir=3D"ltr" class=3D"gmail_attr">On Mon, 18 Mar 2024 at 10:56, vedant pat=
el &lt;<a href=3D"mailto:vedantpatel297@gmail.com">vedantpatel297@gmail.com=
</a>&gt; wrote:<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 dir=3D"ltr"><div dir=3D"auto" style=3D"color:rgb(11,83,148);font-famil=
y:verdana,sans-serif;font-size:12.8px">Hello=C2=A0There,</div><div dir=3D"a=
uto" style=3D"color:rgb(11,83,148);font-family:verdana,sans-serif;font-size=
:12.8px"><br></div><div dir=3D"auto" style=3D"color:rgb(11,83,148);font-fam=
ily:verdana,sans-serif;font-size:12.8px">Recently, we&#39;ve encountered so=
me performance issues with the ODBC driver provided by Postgres. Upon inves=
tigation, we noticed that switching from the UNICODE to ANSI driver resulte=
d in performance improvements for some queries, albeit at the expense of ot=
hers.<br><br>To delve deeper into this matter, I conducted tests using a Py=
thon script with the psycopg2 library, and the results were significantly b=
etter. However, to address this issue comprehensively, I&#39;ve explored al=
ternative ODBC drivers available in the market. While some minor improvemen=
ts were observed in a few queries with a different driver, the overall perf=
ormance remains a concern.<br><br>Given your extensive experience in this a=
rea, I would greatly appreciate your insights and recommendations on which =
ODBC driver would be most suitable for our use case. Any advice or suggesti=
ons you could offer would be immensely helpful in resolving this performanc=
e issue.<br><br></div><span style=3D"font-size:12.8px;color:rgb(80,0,80);fo=
nt-family:arial,helvetica,sans-serif"><div style=3D"font-family:verdana,san=
s-serif;color:rgb(11,83,148)">Let me know in case of any questions or conce=
rns.=C2=A0</div><div style=3D"font-family:verdana,sans-serif;color:rgb(11,8=
3,148)"><br></div></span><div dir=3D"auto" style=3D"color:rgb(11,83,148);fo=
nt-family:verdana,sans-serif;font-size:12.8px">Thanks,</div></div>
</blockquote></div>

--000000000000daa3ef0613f3d12c--