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