Re: Slow query through ODBC

Поиск
Список
Период
Сортировка
От Ludek Finstrle
Тема Re: Slow query through ODBC
Дата
Msg-id 20060210113803.GB7912@soptik.pzkagis.cz
обсуждение исходный текст
Ответ на Re: Slow query through ODBC  (Arnaud Lesauvage <thewild@freesurf.fr>)
Список 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 по дате отправления:

Предыдущее
От: Ludek Finstrle
Дата:
Сообщение: Re: LATIN1/9 conversion....
Следующее
От: "Magnus Hagander"
Дата:
Сообщение: Re: Slow query through ODBC