X-Original-To: pgsql-hackers-win32-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 05CE332A4FC; Thu, 14 Oct 2004 18:02:06 +0100 (BST) 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 76102-09; Thu, 14 Oct 2004 17:02:03 +0000 (GMT) Received: from hotmail.com (bay10-dav14.bay10.hotmail.com [64.4.37.188]) by svr1.postgresql.org (Postfix) with ESMTP id 79BAA32A273; Thu, 14 Oct 2004 18:02:02 +0100 (BST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 14 Oct 2004 10:02:01 -0700 Received: from 199.249.167.148 by BAY10-DAV14.phx.gbl with DAV; Thu, 14 Oct 2004 17:01:43 +0000 X-Originating-IP: [199.249.167.148] X-Originating-Email: [mikesmialek2@hotmail.com] X-Sender: mikesmialek2@hotmail.com From: "MikeSmialek2@Hotmail.com" To: , Subject: Performance on Win32 vs Cygwin Date: Thu, 14 Oct 2004 12:01:38 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Message-ID: X-OriginalArrivalTime: 14 Oct 2004 17:02:01.0458 (UTC) FILETIME=[85F02D20:01C4B20F] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/64 X-Sequence-Number: 2354 Hi, We are experiencing slow performance on 8 Beta 2 Dev3 on Win32 and are trying to determine why. Any info is appreciated. We have a Web Server and a DB server both running Win2KServer with all service packs and critical updates. An ASP page on the Web Server hits the DB Server with a simple query that returns 205 rows and makes the ASP page delivered to the user about 350K. On an ethernet lan a client pc perceives just under 1 sec performance with the following DB Server configuration: PIII 550Mhz 256MB RAM 7200 RPM HD cygwin Postgresql 7.1.3 PGODBC 7.3.2 We set up another DB Server with 8 beta (same Web Server, same network, same client pc) and now the client pc perceives response of just over 3 sec with the following DB server config: PIII 700 Mhz 448MB RAM 7200 RPM HD 8 Beta 2 Dev3 on Win32 running as a service Is the speed decrease because it's a beta? Is the speed decrease because it's running on Win instead of cygwin? We did not install cygwin on the new DB Server. Thanks, Mike