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
Attachment:
signature.asc
Description: OpenPGP digital signature
