| From: | Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> |
|---|---|
| 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:25:04 |
| Message-ID: | 45B5D470.7030502@tpf.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Jiří Nouza wrote:
> Hello,
> I've read a post [1] about how MS Access is enjoyable and efficient when tables are connected to MS SQL.
>
> 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'm not able to bind comboboxes directly to larger (more than 60 records) linked table because unrolling takes 20 sec
Aren't you turning on ODBC trace ?
regards,
Hiroshi Inoue
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ludek Finstrle | 2007-01-23 09:26:36 | Re: linked tables in MS Access |
| Previous Message | Jiří Nouza | 2007-01-23 09:10:45 | linked tables in MS Access |