Re: Extremely Low performance with ODBC

On Fri, May 23, 2008 at 2:45 PM, Sebastian Rychter
<srychter(at)anvet(dot)com(dot)ar> wrote:

> Thanks for your response. I did that in the first place and found that both
> explain reports where quite similar. I've got both reports: From pgadmin it
> took 7288 ms, and from VFP took 6446 ms (of course, that's the time
> calculated within the explain analyze, and not the real elapsed time).

actually it looks like 7.288ms and 6.446ms. ;)

> That's why I assume the ODBC driver is taking its own time for parsing or
> something like that- around 2 minutes actually :)

Checking the Postgresql logs would be really helpful here.

1) note the time that you issue the query from your client FE.
2) note the time in the pg server logs that the server gets the passed
query string.
2b) check for any disparity between 1) and 2).
3) check that the query is exactly the same as you've hand coded in pg-admin
4) also check the query duration when issued by ODBC in the postgresql
log to see if it is really taking 2 minutes.

It would be nice to see the snippet of the PG log showing this ODBC
query with associate duration times.

--
Regards,
Richard Broersma Jr.

Visit the Los Angles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug