Postgres Pro
Downloads
Home   >   mailing lists

ODBC driver performance on large result-sets - Mailing list pgsql-odbc

From Alistair Bayley
Subject ODBC driver performance on large result-sets
Date
Msg-id 79d7c4980805281351g40d2b007i7ea702bc1608cb30@mail.gmail.com
Whole thread Raw
Responses Re: ODBC driver performance on large result-sets  ("Alistair Bayley" <alistair@abayley.org>)
List pgsql-odbc
Tree view 
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

pgsql-odbc by date:

Previous
From: "Vivek Gupta"
Date:
Subject: FETCH_MAX parameter
Next
From: "Alistair Bayley"
Date:
Subject: Re: ODBC driver performance on large result-sets