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 <m...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
