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
|
Список | 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 по дате отправления: