Re: Extremely Low performance with ODBC

Sebastian Rychter wrote:
>
> Hi, I'm executing a query through psql ODBC which is taking around 2
> minutes to complete. When I run it from PgAdmin it takes less than 3
> seconds.
>
> The query itself has :
>
> . 15 inner joins (from just around 10 different tables -- the other
> inner joins are using different aliases for the same tables)
>
> . Select statement returns 1 field.
>
> . the testing database is selecting only 1 record.
>
>
>
> Taking a look at the explain analyze report, I see they are both quite
> the same and tested the ODBC driver through Visual Foxpro and Vb.NET
> as well, taking both around 2 minutes to finish.
>
>
>
> Any idea ?
>
Don't know if this is your issue but we had a legacy VB/ODBC app that
selected a handful (10 or fewer) records from a single table but for
some reason behind the scenes we discovered that the app selected the
whole table. As you might imagine, this caused very poor performance on
large tables. EXPLAIN will not reveal this. You might want to set the
server to log all transactions and see what the app is really doing at
the server level.

Cheers,
Steve