Re: Performance in odbc driver version 7.03.0100 - Mailing list pgsql-odbc

From Chris Gamache
Subject Re: Performance in odbc driver version 7.03.0100
Date
Msg-id 20030624191527.11217.qmail@web13804.mail.yahoo.com
Whole thread Raw
In response to Performance in odbc driver version 7.03.0100  (Somenath Das <SDas@longboard.com>)
List pgsql-odbc
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

pgsql-odbc by date:

Previous
From: "Patrick Bye (WFF)"
Date:
Subject: Problem with 07.03.0100 in ASP.NET page
Next
From: Richard Huxton
Date:
Subject: Client software vs cursor problem?