public inbox for [email protected]  

help / color / mirror / Atom feed

From: Quinton Lawson <[email protected]>
To: [email protected]
Subject: Windows 2000 Slower Than Windows XP
Date: Sat, 22 Jan 2005 19:57:50 -0600
Message-ID: <000801c500ee$f775dc00$6501a8c0@travis> (raw)

I have been having quite a time trying to figure this one out.  I have installed PostgreSQL OLE DB drivers (ver 1.0.0.15) on two separate machines.  The only difference between the two machines is the OS, 2000 Pro (SP4) and XP Pro (SP2) and both are fully updated from fresh installs.  The PostgreSQL 8.0 server is running on another Windows XP Pro machine (SP2, fully updated).

I am performing a Select query like this: 
SELECT column1, column2, column3 FROM table1 WHERE column4 = 'value1' AND column5 ='value2' ORDER BY column1, column2;

Connection String:
Provider=PostgreSQL.1;Password="";User ID=client1;Data Source=server;Location=Media Database;Extended Properties=""

The results take approximately 2 seconds on the XP machine and 8 seconds on the 2000 machine.

Explain Analyze yields nearly identical times (45ms) between the two.

Any ideas why this is occuring?

Thank You,
qlawson

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Windows 2000 Slower Than Windows XP
  In-Reply-To: <000801c500ee$f775dc00$6501a8c0@travis>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox