Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id A9B859FB2F8 for ; Sat, 21 Oct 2006 00:45:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 00426-02 for ; Sat, 21 Oct 2006 03:44:15 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from lists.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id C58D09FB368 for ; Sat, 21 Oct 2006 00:38:50 -0300 (ADT) Received: from [192.168.1.95] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id k9L3cmLu016620 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Fri, 20 Oct 2006 20:38:52 -0700 Message-ID: <45399665.8020505@commandprompt.com> Date: Fri, 20 Oct 2006 20:39:17 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Thunderbird 1.5.0.7 (X11/20060918) MIME-Version: 1.0 To: Merlin Moncure CC: Carlo Stonebanks , pgsql-performance@postgresql.org, alvherre@commandprompt.com Subject: Re: Is ODBC that slow? References: <20061021023211.GA20508@alvh.no-ip.org> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.88.4, clamav-milter version 0.88.4 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Fri, 20 Oct 2006 20:38:52 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200610/454 X-Sequence-Number: 21583 >> > ODBC is often blamed for this sort of thing - I have the 8.01.02 >> release >> > dated 2006.01.31. Everything appears to be at its default setting. >> >> Try Command Prompt's ODBC driver. Lately it has been measured to be >> consistently faster than psqlODBC. I should note that we need to get a build out for Windows for rev 80. Rev 80 is the one the build showing the most promise on Linux32 and 64 bit. It is also the one that reflects the performance metrics we have been seeing. We should have that in a week or so. Sincerely, Joshua D. Drake -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate