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

From Ludek Finstrle
Subject Re: Slow query through ODBC
Date
Msg-id 20060210113803.GB7912@soptik.pzkagis.cz
Whole thread Raw
In response to Re: Slow query through ODBC  (Arnaud Lesauvage <thewild@freesurf.fr>)
List pgsql-odbc
> >>Yes, I really don't understand either !
> >>But even though all use libpq.dll, they might not handle the
> >>data the same way. Mayboe ODBC needs to check for data type,
> >>field length, etc... and the other frontends do not need this
> >>kind of information ?
> >
> >Hm. That's an interesting observation. When you do a query with ODBC, does
> >it do any "extra queries" automatically on the system tables? Enable
> >statement logging on the server and see if something weird shows up.
>
> No, no query on the system tables.
> I am not very familiar with the log though, maybe Ludek could tell
> us more about that ?

If I remember it right we measure the time problem in LIBPQ_send_query
function in connection.c (I'm not sure with filename).
Magnus, could you take a look at the code? Maybe you find the problem.
I'm sorry I have no time for it today.
BTW we change the code between 08.01.0102 and 08.01.0200 from PQexec
to PQsendquery and PQgetresult (I write this from my head so it could
be little different names). But I think Arnaud has problem even with
08.01.0102.

Regards,

Luf

pgsql-odbc by date:

Previous
From: Ludek Finstrle
Date:
Subject: Re: LATIN1/9 conversion....
Next
From: "Magnus Hagander"
Date:
Subject: Re: Slow query through ODBC