X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 381B111F65A7 for ; Thu, 30 Mar 2006 01:57:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 30092-07 for ; Thu, 30 Mar 2006 01:57:14 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ctb-mesg1.saix.net (ctb-mesg1.saix.net [196.25.240.81]) by postgresql.org (Postfix) with ESMTP id E002B11F65EF for ; Thu, 30 Mar 2006 01:57:12 -0400 (AST) Received: from greg (dsl-145-175-122.telkomadsl.co.za [165.145.175.122]) by ctb-mesg1.saix.net (Postfix) with SMTP id F38E453B7 for ; Thu, 30 Mar 2006 07:57:07 +0200 (SAST) Message-ID: <000a01c653be$d312e3c0$0200a8c0@pta.homex.co.za> Reply-To: "Greg Quinn" From: "Greg Quinn" To: References: <000d01c65261$19a3fa40$0200a8c0@pta.homex.co.za> <20060328173213.GO75181@pervasive.com> <442977D7.5060508@commandprompt.com> <006c01c652f9$1ca9c420$0200a8c0@pta.homex.co.za> <000f01c6531f$fcbc0570$0200a8c0@pta.homex.co.za> <442B3282.8070204@calorieking.com> Subject: [Solved] Slow performance on Windows .NET and OleDb Date: Thu, 30 Mar 2006 07:57:23 +0200 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="utf-8"; reply-type=response Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2670 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.346 required=5 tests=[AWL=0.346] X-Spam-Score: 0.346 X-Spam-Level: X-Archive-Number: 200603/604 X-Sequence-Number: 18041 This problem was caused by the OleDb driver. I used a 3rd party .NET provider and it worked, 8000 rows in just over 100ms! Can somebody send me a sample connection string for the PostGreSql native .net driver please? I'm battling to find a valid connection string. Thanks