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