X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EEEB7D1B750 for ; Fri, 18 Jun 2004 12:49:37 -0300 (ADT) 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 34174-08 for ; Fri, 18 Jun 2004 15:49:33 +0000 (GMT) Received: from hotmail.com (bay1-f154.bay1.hotmail.com [65.54.245.154]) by svr1.postgresql.org (Postfix) with ESMTP id 5A065D1B54D for ; Fri, 18 Jun 2004 12:49:32 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 18 Jun 2004 08:49:35 -0700 Received: from 62.49.5.141 by by1fd.bay1.hotmail.msn.com with HTTP; Fri, 18 Jun 2004 15:49:35 GMT X-Originating-IP: [62.49.5.141] X-Originating-Email: [jackhappy6@hotmail.com] X-Sender: jackhappy6@hotmail.com From: "Jack -" To: pgsql-php@postgresql.org Subject: where to put the sql? Date: Fri, 18 Jun 2004 15:49:35 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 18 Jun 2004 15:49:35.0484 (UTC) FILETIME=[DACAABC0:01C4554B] 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: 200406/40 X-Sequence-Number: 2814 Hi In general does it make a performance difference where i put the sql? At the moment I am doing selects in php against views (a few table joins and selects) in postgresql. Should I be doing all the selects and joins on the php side? or on balance should it not really make a big difference? Any pointers / tips appreciated Thanks! Jack _________________________________________________________________ Stay in touch with absent friends - get MSN Messenger http://www.msn.co.uk/messenger