Re: Performance in odbc driver version 7.03.0100

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  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