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

Re: Extremely Low performance with ODBC

From: "Sebastian Rychter" <srychter(at)anvet(dot)com(dot)ar>
To: "'Richard Broersma'" <richard(dot)broersma(at)gmail(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Extremely Low performance with ODBC
Date: 2008-05-23 16:47:56
Message-ID: 018701c8bcf4$c3630df0$4a2929d0$ (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
Thanks.. All logs are already off and I'm just sending one query directly
from the application (from Visual Foxpro using SQL Pass through and in using I've found that the "problem" is that I'm using
implicit joins, and when I change it to explicit Inner Joins the query only
takes 3 seconds (as with PgAdmin). I still can't understand if the problem
resides on the ODBC driver, the Query Planner or it's just a mix of both.

-----Mensaje original-----
De: Richard Broersma [mailto:richard(dot)broersma(at)gmail(dot)com] 
Enviado el: Viernes, 23 de Mayo de 2008 01:04 p.m.
Para: Sebastian Rychter
CC: pgsql-sql(at)postgresql(dot)org
Asunto: Re: [SQL] Extremely Low performance with ODBC

On Thu, May 22, 2008 at 11:29 AM, Sebastian Rychter
<srychter(at)anvet(dot)com(dot)ar> wrote:
> Hi, I'm executing a query through psql ODBC which is taking around 2
> to complete. When I run it from PgAdmin it takes less than 3 seconds.
> Any idea ?

1) turn off all ODBC query logging from both the ODBC driver and the
ODBC administrator.  This feature is a performance killer.  Only use
this feature if you are trying to debug a problem.
2) Some client programs try to perform the joins on the client side
rather than the server side. I would check if the client is actually
passing the actual SQL statement back to the server. If it is trying
to perform the join on the client, it could be a big performance

Richard Broersma Jr.

Visit the Los Angles PostgreSQL Users Group (LAPUG)

__________ NOD32 3124 (20080522) Information __________

This message was checked by NOD32 antivirus system.

In response to


pgsql-sql by date

Next:From: Richard BroersmaDate: 2008-05-23 20:26:27
Subject: Re: Extremely Low performance with ODBC
Previous:From: Richard BroersmaDate: 2008-05-23 16:03:56
Subject: Re: Extremely Low performance with ODBC

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