Request a Demo
Home   >   mailing lists

Extremely Low performance with ODBC - Mailing list pgsql-sql

From Sebastian Rychter
Subject Extremely Low performance with ODBC
Date
Msg-id 004301c8bc39$c43aba40$4cb02ec0$@com.ar
Whole thread
Responses Re: Extremely Low performance with ODBC
Re: Extremely Low performance with ODBC
Re: Extremely Low performance with ODBC
List pgsql-sql
Tree view

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 ?

 

Thanks,

 

Sebastian

pgsql-sql by date:

Previous
From: Niklas Johansson
Date:
Subject: Re: Substract queries
Next
From: "Medi Montaseri"
Date:
Subject: Query question