X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E936311F670A for ; Fri, 28 Apr 2006 00:19:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 01720-02 for ; Fri, 28 Apr 2006 00:19:32 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from coe.tamu.edu (edsun.coe.tamu.edu [165.91.232.6]) by postgresql.org (Postfix) with ESMTP id 5136F11F6284 for ; Fri, 28 Apr 2006 00:19:31 -0300 (ADT) Received: (from root@localhost) by bruner.coe.tamu.edu (8.13.1/8.13.1) id k3S3HeiW014630 for pgsql-admin@postgresql.org; Thu, 27 Apr 2006 22:17:40 -0500 Received: from coe.tamu.edu (coe.tamu.edu [165.91.232.6]) by coe.tamu.edu (8.11.7p1+Sun/8.12.11) with ESMTP id k3S3ItU28755 for ; Thu, 27 Apr 2006 22:18:55 -0500 (CDT) Date: Thu, 27 Apr 2006 22:18:55 -0500 (CDT) From: "Ben K." To: pgsql-admin@postgresql.org Subject: Re: New system recommendations Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by AMaViS 0.3.12 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/319 X-Sequence-Number: 21488 > Record insertion is done via an ODBC call to a stored procedure from a > Windows based host monitor" I wondered what this stored procedure was (is it a function or something outside postgresql). There was an interesting article on odbc - that application code can make big differences in database related performance. http://ourworld.compuserve.com/homepages/Ken_North/ODBCPERF.HTM Thought odbc performance might be also a thing to consider but this article seemed to attest otherwise. Hence the question. Regards, Ben K.