Re: PostGres ODBC too slow

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(at)gmail(dot)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,
>