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 6FB309DCA43 for ; Thu, 19 Jan 2006 13:38:19 -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 62512-04 for ; Thu, 19 Jan 2006 13:38:18 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from server10.araisoft.com (server10.araisoft.com [72.9.228.195]) by postgresql.org (Postfix) with ESMTP id B62B59DCA06 for ; Thu, 19 Jan 2006 13:38:16 -0400 (AST) Received: from localhost (unknown [127.0.0.1]) by server10.araisoft.com (Postfix) with ESMTP id 6AD853D6200D for ; Thu, 19 Jan 2006 09:38:13 -0800 (PST) Received: from server10.araisoft.com ([127.0.0.1]) by localhost (server10.araisoft.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09282-02 for ; Thu, 19 Jan 2006 09:38:07 -0800 (PST) Received: from uni (uni.cs.ucr.edu [138.23.204.215]) by server10.araisoft.com (Postfix) with ESMTP id 172DA3D6200B for ; Thu, 19 Jan 2006 09:38:07 -0800 (PST) From: "Benjamin Arai" To: Subject: Stored Procedures Date: Thu, 19 Jan 2006 09:38:01 -0800 Message-ID: <000001c61d1f$19fed2c0$d7cc178a@uni> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0001_01C61CDC.0BDB92C0" X-Mailer: Microsoft Office Outlook 11 Thread-Index: AcYdHxfGZh71Ht+kT9CLUyLvKorDqg== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 X-Virus-Scanned: by amavisd-new at araisoft.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.185 required=5 tests=[AWL=0.184, HTML_MESSAGE=0.001] X-Spam-Score: 0.185 X-Spam-Level: X-Archive-Number: 200601/327 X-Sequence-Number: 16805 This is a multi-part message in MIME format. ------=_NextPart_000_0001_01C61CDC.0BDB92C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, Will simple queries such as "SELECT * FROM blah_table WHERE tag='x'; work any faster by putting them into a stored procedure? Benjamin Arai barai@cs.ucr.edu http://www.benjaminarai.com ------=_NextPart_000_0001_01C61CDC.0BDB92C0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

Will = simple queries=20 such as "SELECT * FROM blah_table WHERE tag=3D'x'; work any faster by = putting them=20 into a stored procedure?

Benjamin = Arai

barai@cs.ucr.edu

http://www.benjaminarai.com

------=_NextPart_000_0001_01C61CDC.0BDB92C0--