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