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
