Message-ID: <gh-postgresql-interfaces-psqlodbc-32-c2232638820@github.com>
From: "FabianStoehr (@FabianStoehr)" <noreply+FabianStoehr@github.com>
To: "postgresql-interfaces/psqlodbc" <noreply+postgresql-interfaces-psqlodbc@github.com>
Date: Wed, 17 Jul 2024 07:39:24 +0000
Subject: Re: [postgresql-interfaces/psqlodbc] issue #32: Slow Connection with ODBC Driver
In-Reply-To: <gh-postgresql-interfaces-psqlodbc-32@github.com>
References: <gh-postgresql-interfaces-psqlodbc-32@github.com>
List-Id: <gh-postgresql-interfaces-psqlodbc.github.com>
X-GitHub-Author-Login: FabianStoehr
X-GitHub-Comment-Id: 2232638820
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-2232638820
Content-Type: text/plain; charset=utf-8

What information do you need?
We use the latest ms access version with standard settings (I couldn't find settings in ms access that might affect this anyways).
Also postgres runs on standard settings (except the modification for SSL encryption and a different port mapping).
So from my perspective everyone should get the same issue when downloading ms access and postgresql now and uses odbc to connect them (remotely). I use the latest psqlodbc version 16 00 0005.
I don't use declare/fetch and I increased the batch size to 50000. This didn't seem to change anything.
I tried this from two different computers in total different networks. The problem remains.
What options do you think I can set to make it work faster?