> 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.
In response to
pgsql-odbc by date
|Next:||From: Igor Neyman||Date: 2008-06-03 13:47:31|
|Subject: odbc install error on Windows|
|Previous:||From: Alistair Bayley||Date: 2008-05-28 20:51:23|
|Subject: ODBC driver performance on large result-sets|