From: | Chris Gamache <cgg007(at)yahoo(dot)com> |
---|---|
To: | "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Performance in odbc driver version 7.03.0100 |
Date: | 2003-06-24 19:15:27 |
Message-ID: | 20030624191527.11217.qmail@web13804.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)longboard(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2003-06-25 10:40:06 | Client software vs cursor problem? |
Previous Message | Armando Bañuelos | 2003-06-23 22:30:03 | Hi! |