Message-ID: From: "khogan02 (@khogan02)" To: "postgresql-interfaces/psqlodbc" Date: Thu, 12 Sep 2024 14:50:43 +0000 Subject: Re: [postgresql-interfaces/psqlodbc] issue #32: Slow Connection with ODBC Driver In-Reply-To: References: List-Id: X-GitHub-Author-Login: khogan02 X-GitHub-Comment-Id: 2346520585 X-GitHub-Comment-Type: issue_comment X-GitHub-Issue: 32 X-GitHub-Repo: postgresql-interfaces/psqlodbc X-GitHub-Type: comment X-GitHub-Url: https://github.com/postgresql-interfaces/psqlodbc/issues/32#issuecomment-2346520585 Content-Type: text/plain; charset=utf-8 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, or unsubscribe. You are receiving this because you commented.Message ID: ***@***.***>