Re: [SQL] Extremely Low performance with ODBC

2008-05-28 Thread Bruce Momjian
Sebastian Rychter wrote:
> 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.

Uh, why is ODBC modifyingin the 'geqo' variable?

-- 
  Bruce Momjian  <[EMAIL PROTECTED]>http://momjian.us
  EnterpriseDB http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

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


Re: [SQL] Extremely Low performance with ODBC

2008-05-28 Thread Sebastian Rychter
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
En nombre de Steve Midgley
Enviado el: MiƩrcoles, 28 de Mayo de 2008 03:29 a.m.
Para: [EMAIL PROTECTED]; pgsql-sql@postgresql.org
CC: [EMAIL PROTECTED]
Asunto: Re: [SQL] Extremely Low performance with ODBC

At 09:20 PM 5/27/2008, [EMAIL PROTECTED] wrote:
>Date: Tue, 27 May 2008 09:29:56 -0700
>From: "Richard Broersma" <[EMAIL PROTECTED]>
>To: "Sebastian Rychter" <[EMAIL PROTECTED]>
>Cc: pgsql-sql@postgresql.org
>Subject: Re: Extremely Low performance with ODBC
>Message-ID: 
><[EMAIL PROTECTED]>
>
>On Mon, May 26, 2008 at 9:34 PM, Sebastian Rychter
><[EMAIL PROTECTED]> 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@postgresql.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



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