| From: | "Stefan Wolf" <sw(at)zpmt(dot)de> |
|---|---|
| To: | <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | MS-ACCESS 2010, ODBC 12.01, Out of Memory |
| Date: | 2020-03-02 14:25:17 |
| Message-ID: | 000001d5f09e$660c0360$32240a20$@zpmt.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Win10-Client: MS-ACCESS 2010 (32-Bit), ODBC-Driver: 12.01
Linux-Server (1): PostgreSQL 12.2
Linux-Server (2): PostgreSQL 9.6
We are currently migrating form PG 9.6. to 12.x.
We've created System-DSNs (PostgreSQL Unicode) with [Defaults] for both
Server.
In MS-ACCESS our biggest Server-Tables (>14.000.000 Rows) can be opened (on
both Servers).
But it takes a lot of time and uses a lot of memory - more than 450MB.
The indexes are recognized an filtering is fast.
Trying to open more than one "big table" will result in MS-ACCESS "Out of
memory".
Best regards
-Stefan Wolf-
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthias Coene | 2020-03-12 15:04:52 | fn TIMESTAMPADD |
| Previous Message | Inoue, Hiroshi | 2020-02-28 12:32:30 | Re: How to fix psqlODBC driver regression to get error message details |