Re: Libpq is very slow on windows but fast on linux.

Thanks, but no, it's using ip, and after the connection has been
established etc. the 3500ms it the total query time on windows vs
800ms on linux. Same server, so I think it is related to libpq
implementation on windows.

I also get the same results running XP in a virtualbox on a linux
machine, while the linux host machine is getting 800ms.

On Sun, Nov 7, 2010 at 12:59 PM, Joe Conway <mail(at)joeconway(dot)com> wrote:
> 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
>
>

--
--

Rob