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: Mon, 18 Mar 2024 14:49:21 -0400
Message-ID: <CADK3HHK471z_+FXxKL=SonAc8p15aHoqm7XVKsCV5O51y4_HQw@mail.gmail.com> (raw)
In-Reply-To: <CAL4ovZoYjU0NiHg+aYYvzzPChjyYpFGyWt8QwDvkvt91UessZA@mail.gmail.com>
References: <CAL4ovZoYjU0NiHg+aYYvzzPChjyYpFGyWt8QwDvkvt91UessZA@mail.gmail.com>

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: <CADK3HHK471z_+FXxKL=SonAc8p15aHoqm7XVKsCV5O51y4_HQw@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