Re: Slow query through ODBC

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: Slow query through ODBC
Дата
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE6C7FDB@algol.sollentuna.se
обсуждение исходный текст
Ответ на Slow query through ODBC  (Arnaud Lesauvage <thewild@free.fr>)
Ответы Re: Slow query through ODBC  (Ludek Finstrle <luf@pzkagis.cz>)
Список 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.

That's very interestnig information. Because that was one thing that was
different.

Arnaud, any chance you can giev it a try with 8.01.0200?

//Magnus

В списке pgsql-odbc по дате отправления:

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