public inbox for [email protected]  

help / color / mirror / Atom feed

From: Dave Cramer <[email protected]>
To: vedant patel <[email protected]>
Cc: [email protected]
Subject: Re: PostGres ODBC too slow
Date: Wed, 20 Mar 2024 07:17:29 -0400
Message-ID: <CADK3HHJc-ShnErp5=b_KzNz76xdYyn1qd8SzeULun=SVBfTmOQ@mail.gmail.com> (raw)
In-Reply-To: <CAL4ovZrHYYROkWuY_0yn4a2Ca32xQeBL9zB9PcO9qpkPPhAVBg@mail.gmail.com>
References: <CAL4ovZoYjU0NiHg+aYYvzzPChjyYpFGyWt8QwDvkvt91UessZA@mail.gmail.com>
	<CADK3HHK471z_+FXxKL=SonAc8p15aHoqm7XVKsCV5O51y4_HQw@mail.gmail.com>
	<CAL4ovZrHYYROkWuY_0yn4a2Ca32xQeBL9zB9PcO9qpkPPhAVBg@mail.gmail.com>

HI Vedant,

Can you share the SQL that is slow. We can't fix this if we don't have a
specific problem to look at.

Dave Cramer
www.postgres.rocks


On Wed, 20 Mar 2024 at 02:08, vedant patel <[email protected]> wrote:

> Hello Dave,
>
> We have tried the retrieval using python library psycopg2 and found that
> it is taking less amount of time for retrieval. And when we create odbc and
> use pyodbc it is taking a large amount of time for that odbc. Along with
> that our main application is in PowerBuilder and we need to use ODBC for
> that one. We checked the ODBC driver with PowerBuilder and it is taking too
> much time.
>
> Thanks,
>
> On Tue, Mar 19, 2024 at 12:19 AM Dave Cramer <[email protected]>
> wrote:
>
>> 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 <[email protected]>
>> 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,
>>>
>>

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: PostGres ODBC too slow
  In-Reply-To: <CADK3HHJc-ShnErp5=b_KzNz76xdYyn1qd8SzeULun=SVBfTmOQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox