Re: Slow query through ODBC - Mailing list pgsql-odbc

From Ludek Finstrle
Subject Re: Slow query through ODBC
Date
Msg-id 20060123133454.GA23076@soptik.pzkagis.cz
Whole thread Raw
In response to Re: Slow query through ODBC  (Arnaud Lesauvage <thewild@freesurf.fr>)
List pgsql-odbc
> I tried both parameters (they look OK because ADO did not throw an
> error), but they did not help.

I think it. But we could test it at first :-)

> Maybe I should add that the query is stored in an ADO recordset,
> which is read-only and forward-only ?

This is the best situation for psqlODBC driver.

> It is the .open method of this recordset that actually takes 30
> seconds to run.

.open ADO contains a lot of SQL* commands for ODBC.
I need the mylog or (the better for me) example data to reproduce it
here.

> >If I can't find the problem in mylog output could you create example
> >data?
>
> I sure could !

Great.

> I'll try some other parameters before (I will use the File-DSN
> panel to generate connectionstrings, I should have thought about
> it before !), and I'll tell you whether I found something or not.

Ok. I'm looking for note from you.
If you'll not find the way please send me the parsed log or
example data with SELECT.

Regards,

Luf

pgsql-odbc by date:

Previous
From: "Philippe Lang"
Date:
Subject: Problem with NT 4.0 / driver 08.01.0102
Next
From: Ludek Finstrle
Date:
Subject: Re: Problem with NT 4.0 / driver 08.01.0102