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@joeconway.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