-
Notifications
You must be signed in to change notification settings - Fork 10
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Slow Connection with ODBC Driver #32
Comments
Hard to say. How many rows are there, and how wide are the rows ? |
Hi Dave, It depends. In my example with 40 minutes it was roughly 16000 rows with around 30 fields. |
Well there's not enough information here for me to tell what is "normal" could be microsoft access could be different connections. 40 minutes is not acceptable whatever the case |
What information do you need? |
Hi there,
I'm using psqlodbc driver to connect to my remote postgresql server via ms access.
The connection is established even with SSL encryption and everything works except that the connection seems to be super slow.
I did all kinds of queries including adding rows to an existing table, updating singe values or using a big update query.
It really seems to depend of the number of objects that are stored i.e. the number of lines that need to be updated and not the number of attributes or fields.
It can't be the internet connection since importing the same amount of data with a csv file via pgadmin only takes 2 seconds while the query via ms access took 40 mins.
Can anybody help me? I tried to activate row versioning but that doesn't really help.
I think the problem already starts there: when I just open the linked table in ms access (basically select * from ...) it doesn't load all rows but only the top something and when i start scrolling down more rows appear. grouping queries work fine tho and give me the correct count results.
I really hope someone know the answer to this.
It would be great if I could just update tables in my remote postgresql database from my ms access database on my client pc.
Many thanks in advance!
Fabian
The text was updated successfully, but these errors were encountered: