Re: ODBC driver performance on large result-sets

["Alistair Bayley" <alistair(at)abayley(dot)org>]

> 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.

Never mind. I just noticed that the ODBC driver has "disable genetic
optimizer" checked. If I uncheck then presumably the query gets some
decent optimisation, and runs as quickly as the libpq version. Is this
a sensible default setting?

Sorry for the spam.

Alistair