X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6B0923A501F for ; Sun, 23 Jan 2005 01:58:11 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 37673-02 for ; Sun, 23 Jan 2005 01:57:58 +0000 (GMT) Received: from lakermmtao11.cox.net (lakermmtao11.cox.net [68.230.240.28]) by svr1.postgresql.org (Postfix) with ESMTP id 3D94F3A3F64 for ; Sun, 23 Jan 2005 01:58:00 +0000 (GMT) Received: from travis ([68.109.221.28]) by lakermmtao11.cox.net (InterMail vM.6.01.04.00 201-2131-117-20041022) with SMTP id <20050123015800.LVBT1657.lakermmtao11.cox.net@travis> for ; Sat, 22 Jan 2005 20:58:00 -0500 Message-ID: <000801c500ee$f775dc00$6501a8c0@travis> From: "Quinton Lawson" To: Subject: Windows 2000 Slower Than Windows XP Date: Sat, 22 Jan 2005 19:57:50 -0600 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0005_01C500BC.A7407C40" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2527 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.846 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, HTML_50_60, HTML_MESSAGE X-Spam-Level: *** X-Archive-Number: 200501/1226 X-Sequence-Number: 72175 This is a multi-part message in MIME format. ------=_NextPart_000_0005_01C500BC.A7407C40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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:=20 SELECT column1, column2, column3 FROM table1 WHERE column4 =3D 'value1' = AND column5 =3D'value2' ORDER BY column1, column2; Connection String: Provider=3DPostgreSQL.1;Password=3D"";User ID=3Dclient1;Data = Source=3Dserver;Location=3DMedia Database;Extended Properties=3D"" 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 ------=_NextPart_000_0005_01C500BC.A7407C40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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

I am performing a Select query like=20 this:

SELECT column1, column2, = column3 FROM table1=20 WHERE column4 =3D 'value1' AND column5 =3D'value2' ORDER BY column1,=20 column2;

Connection String:

Provider=3DPostgreSQL.1;Password=3D"";User=20 ID=3Dclient1;Data Source=3Dserver;Location=3DMedia Database;Extended=20 Properties=3D""

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

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

Any ideas why this is = occuring?

Thank You,

qlawson

------=_NextPart_000_0005_01C500BC.A7407C40--