Skip site navigation (1) Skip section navigation (2)

Re: ODBC driver performance on large result-sets

From: "Alistair Bayley" <alistair(at)abayley(dot)org>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC driver performance on large result-sets
Date: 2008-05-28 21:00:13
Message-ID: 79d7c4980805281400w78d7ba9akb6dc5bdf0ff9af78@mail.gmail.com (view raw or flat)
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.

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

In response to

pgsql-odbc by date

Next:From: Igor NeymanDate: 2008-06-03 13:47:31
Subject: odbc install error on Windows
Previous:From: Alistair BayleyDate: 2008-05-28 20:51:23
Subject: ODBC driver performance on large result-sets

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group