From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | Rob Brown-Bayliss <r(dot)brown(dot)bayliss(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Libpq is very slow on windows but fast on linux. |
Date: | 2010-11-06 23:59:22 |
Message-ID: | 4CD5EBDA.30902@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 11/06/2010 04:54 PM, Rob Brown-Bayliss wrote:
> Hi
>
> I have a problem with libpq on windows. Connecting to a db and running
> a "select * from some_table;" is very slow.
>
> The table has only 1800 rows, 7 columns. No blobs etc.
>
> The query is taking around 3500ms, in linux it takes around 800ms.
> (About 500ms is network time, the server is on the opposite side of
> the world from my location.)
>
> The hardware is identical (dual boot)
>
> Why does this so long in windows? I tested in pqsl, and pgadmin to
> rule out errors in the app code.
>
> Any advice or clues? I need the app to work on both platforms.
Just a guess, but maybe DNS lookup time? Try using IP address instead of
FQDN.
HTH,
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2010-11-07 00:06:12 | Re: Libpq is very slow on windows but fast on linux. |
Previous Message | Rob Brown-Bayliss | 2010-11-06 23:54:04 | Libpq is very slow on windows but fast on linux. |