From: | Ludek Finstrle <luf(at)pzkagis(dot)cz> |
---|---|
To: | Jiří Nouza <nouza(at)seznam(dot)cz> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: linked tables in MS Access |
Date: | 2007-01-23 09:26:36 |
Message-ID: | 20070123092636.GB8408@soptik.pzkagis.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
> But I have MS Access front end containing linked tables to Postgres
> via ODBC. And I'm struggling with slow performance. When I want to
> open a table which contains about 8000 records it takes more then
> 20 sec. When I want to move cursor at the last record it takes more
> than 60 extra seconds.
>
> I've already checked Postgres server log and MS Access queries are
> executed quickly (<500 ms).
>
> Is this normal behavior? Does MS Access cooperates with MS SQL such
> better than with other DBMS via odbc?
I see no description of your configuration.
What's your ODBC settings? What ODBC driver do you use? What OS?
I hope you haven't enabled the mylog output.
How long takes it the psql to show 8000 records?
BTW let's try play with "use declare/fetch" and "cache size" at first.
And mylog output could help you to see where's the problem.
Regards,
Luf
From | Date | Subject | |
---|---|---|---|
Next Message | Philippe Lang | 2007-01-23 09:32:47 | Re: linked tables in MS Access |
Previous Message | Hiroshi Inoue | 2007-01-23 09:25:04 | Re: linked tables in MS Access |