Re: PostGres ODBC too slow

2024-03-15 Thread vedant patel
Thanks Adrian, I have been to the articles but it didn't help. Many of them have mentioned this type of issues but not the solution. And my main concern is if python library is able to perform fast operation why ODBC is too much slow. And I have to use ODBC for my application which is in power

Re: PostGres ODBC too slow

2024-03-15 Thread Adrian Klaver
On 3/15/24 10:58 AM, vedant patel wrote: Thanks Adrian, I have been to the articles but it didn't help. Many of them have mentioned this type of issues but not the solution. That is why you should ask over on the ODBC list, that is where the folks who develop and use the driver hang out.

Re: PostGres ODBC too slow

2024-03-15 Thread Adrian Klaver
On 3/15/24 3:40 AM, vedant patel 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

PostGres ODBC too slow

2024-03-15 Thread vedant patel
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