From: | "Magnus Hagander" <mha(at)sollentuna(dot)net> |
---|---|
To: | "Ludek Finstrle" <luf(at)pzkagis(dot)cz>, "Arnaud Lesauvage" <thewild(at)freesurf(dot)fr> |
Cc: | <pgsql-odbc(at)postgresql(dot)org>, "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
Subject: | Re: Slow query through ODBC |
Date: | 2006-02-10 11:39:27 |
Message-ID: | 6BCB9D8A16AC4241919521715F4D8BCE6C7FDB@algol.sollentuna.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Clarke | 2006-02-10 11:41:13 | Re: LATIN1/9 conversion.... |
Previous Message | Ludek Finstrle | 2006-02-10 11:38:03 | Re: Slow query through ODBC |