Thread: Performance in odbc driver version 7.03.0100

Performance in odbc driver version 7.03.0100

From
Somenath Das
Date:
Hi,

Performance through odbc driver is very slow in my case.
I ran same query in psql and it took 0.60 msecs
where as the same query took 29 msec
when I ran it through my client application which is using odbc.

Is there anything I am missing in my configuration or this is a well known
behavior ?

Any help from you is really appreciated.

Thanks
Somenath



Re: Performance in odbc driver version 7.03.0100

From
Chris Gamache
Date:
Check to see if SQL logging is turned on in the ODBC manager and in the PgSQL
driver information screen. SQL logging has a whole lot of overhead!

Your network throughput also has a hand in the speed of inquiries. If your
"client" application was accessing the database natively, and ODBC was
accessing it over the network, you'd experience a speed difference.

HTH,

CG

--- Somenath Das <SDas@longboard.com> wrote:
> Hi,
>
> Performance through odbc driver is very slow in my case.
> I ran same query in psql and it took 0.60 msecs
> where as the same query took 29 msec
> when I ran it through my client application which is using odbc.
>
> Is there anything I am missing in my configuration or this is a well known
> behavior ?
>
> Any help from you is really appreciated.
>
> Thanks
> Somenath
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html


__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com