Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 9B12B133616B for ; Sun, 3 Apr 2011 04:02:17 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 57690-02 for ; Sun, 3 Apr 2011 07:02:10 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og119.obsmtp.com (exprod7og119.obsmtp.com [64.18.2.16]) by mail.postgresql.org (Postfix) with ESMTP id 9D2391337B61 for ; Sun, 3 Apr 2011 04:02:09 -0300 (ADT) Received: from source ([209.85.215.47]) (using TLSv1) by exprod7ob119.postini.com ([64.18.6.12]) with SMTP ID DSNKTZgbcM3/0LB/FImJonkk0XsqXEB0CBJu@postini.com; Sun, 03 Apr 2011 00:02:10 PDT Received: by ewy5 with SMTP id 5so1838471ewy.34 for ; Sun, 03 Apr 2011 00:02:07 -0700 (PDT) Received: by 10.213.0.211 with SMTP id 19mr1020994ebc.145.1301814125530; Sun, 03 Apr 2011 00:02:05 -0700 (PDT) Received: from [192.168.1.183] (dsl-hkibrasgw2-ff7ac300-240.dhcp.inet.fi [88.195.122.240]) by mx.google.com with ESMTPS id x54sm2483664eeh.26.2011.04.03.00.02.02 (version=TLSv1/SSLv3 cipher=OTHER); Sun, 03 Apr 2011 00:02:02 -0700 (PDT) Message-ID: <4D981B65.8030209@enterprisedb.com> Date: Sun, 03 Apr 2011 10:01:57 +0300 From: Heikki Linnakangas User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; fi-FI; rv:1.9.1.16) Gecko/20110307 Icedove/3.0.11 MIME-Version: 1.0 To: Eliot Gable CC: pgsql-performance@postgresql.org Subject: Re: C on Client versus C on Server References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201104/5 X-Sequence-Number: 43067 On 02.04.2011 21:52, Eliot Gable wrote: > 1) Each select statement from the User Client C Module would be a separate > transaction which would drastically increase transaction overhead for the > whole set of requests. You could wrap the statements in BEGIN-COMMIT in the client code. > 2) Writing the billing data at the end would mean that I not only have to > pull all the data down to the User Client, I must also push the data back up > to the server for writing the billing records. Yeah, that sounds right. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com