Re: Extremely Low performance with ODBC

["Sebastian Rychter" <srychter(at)anvet(dot)com(dot)ar>]

Thanks. Hiroshi sent me a possible solution (which might be useful for
others going through similar situations), which is to toggle off the
"Disable Genetic Optimizer" from the ODBC driver configuration.

-----Mensaje original-----
De: pgsql-sql-owner(at)postgresql(dot)org [mailto:pgsql-sql-owner(at)postgresql(dot)org]
En nombre de Steve Midgley
Enviado el: Miércoles, 28 de Mayo de 2008 03:29 a.m.
Para: pgsql-sql-owner(at)postgresql(dot)org; pgsql-sql(at)postgresql(dot)org
CC: srychter(at)anvet(dot)com(dot)ar
Asunto: Re: [SQL] Extremely Low performance with ODBC

At 09:20 PM 5/27/2008, pgsql-sql-owner(at)postgresql(dot)org wrote:
>Date: Tue, 27 May 2008 09:29:56 -0700
>From: "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com>
>To: "Sebastian Rychter" <srychter(at)anvet(dot)com(dot)ar>
>Cc: pgsql-sql(at)postgresql(dot)org
>Subject: Re: Extremely Low performance with ODBC
>Message-ID: 
><396486430805270929y6bc3cfcidba5a38592e433e9(at)mail(dot)gmail(dot)com>
>
>On Mon, May 26, 2008 at 9:34 PM, Sebastian Rychter
><srychter(at)anvet(dot)com(dot)ar> wrote:
>
> > I'll keep on looking for any other differences on different logs.. 
> I think I
> > already searched all the Postgresql forums I know and no one ever 
> reported
> > something like that before.

Apologies for the double post on this - I wonder also if you have tried 
alternative Pg ODBC drivers? I found this one while googling around:

http://uda.openlinksw.com/odbc/st/odbc-progress-st/

But I'd guess there are other alternatives. Also, you might check out 
their ADO driver and see if it gives you the same problems..

Just some more grist for the solution mill, hopefully!

Steve


-- 
Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

__________ NOD32 3137 (20080527) Information __________

This message was checked by NOD32 antivirus system.
http://www.eset.com