postgresql-interfaces/psqlodbc GitHub issues and pull requests (mirror)  

help / color / mirror / Atom feed

From: khogan02 (@khogan02) <[email protected]>
To: postgresql-interfaces/psqlodbc <[email protected]>
Subject: Re: [postgresql-interfaces/psqlodbc] issue #32: Slow Connection with ODBC Driver
Date: Thu, 12 Sep 2024 14:50:43 +0000
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

Thanks so much for reaching out.  I do not have a small test case I can share but think I may have finally figured out a solution.  I will reach back out once testing is complete.

From: Dave Cramer ***@***.***>
Sent: Wednesday, September 11, 2024 2:38 PM
To: postgresql-interfaces/psqlodbc ***@***.***>
Cc: Hogan, Kristin (PERATON) ***@***.***>; Comment ***@***.***>
Subject: [EXTERNAL] Re: [postgresql-interfaces/psqlodbc] Slow Connection with ODBC Driver (Issue #32)


I am also seeing very slow response with newer drivers. I support an older application that was using psqlodbc driver v 0903 until the update to postgres v12. Swapping in any newer driver results in SIGNIFICANT decrease in response. Same application, same database, same machine...only the driver changes. Any suggestion? Example: a series of queries runs in < 4min with the 0903 driver, but takes about 90m with the new ones,

Any way you can provide me with a way to replicate this ?

—
Reply to this email directly, view it on GitHub<https://github.com/postgresql-interfaces/psqlodbc/issues/32#issuecomment-2344405849;, or unsubscribe<https://github.com/notifications/unsubscribe-auth/BF5R7CUPSCB6VPRIJUBKJ3DZWCEXVAVCNFSM6AAAAABKW64PLC...;.
You are receiving this because you commented.Message ID: ***@***.***>

view thread (10+ 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: github://postgresql-interfaces/psqlodbc
  Cc: [email protected], [email protected]
  Subject: Re: [postgresql-interfaces/psqlodbc] issue #32: Slow Connection with ODBC Driver
  In-Reply-To: <<[email protected]>>

* 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