| From: | "Alistair Bayley" <alistair(at)abayley(dot)org> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | ODBC driver performance on large result-sets |
| Date: | 2008-05-28 20:51:23 |
| Message-ID: | 79d7c4980805281351g40d2b007i7ea702bc1608cb30@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Attached are two C programs. They borh (I believe) execute the same
query against a PostgreSQL database on my WinXP laptop. The libpq
version runs quickly (in a second or less), while the ODBC version
takes about 40 seconds. Also, while the ODBC version is processing,
the memory usage for one of the postgres server processes goes up
quite a bit, to 140M.
Any suggestions as to what's causing the difference? And, is there
something I can do about it?
Thanks,
Alistair
| Attachment | Content-Type | Size |
|---|---|---|
| manyrows-odbc.c | text/plain | 6.5 KB |
| manyrows-libpq.c | text/plain | 3.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alistair Bayley | 2008-05-28 21:00:13 | Re: ODBC driver performance on large result-sets |
| Previous Message | Vivek Gupta | 2008-05-28 08:23:47 | FETCH_MAX parameter |