X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 57194D1EBF4 for ; Fri, 19 Mar 2004 15:53:07 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 57230-04 for ; Fri, 19 Mar 2004 11:53:05 -0400 (AST) Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222]) by svr1.postgresql.org (Postfix) with ESMTP id 0DA96D1EBB6 for ; Fri, 19 Mar 2004 11:52:59 -0400 (AST) Received: from css120.ihs.com (css120.ihs.com [170.207.105.120]) by mail1.ihs.com (8.12.10/8.12.10) with ESMTP id i2JFpiYE008394; Fri, 19 Mar 2004 08:51:45 -0700 (MST) Date: Fri, 19 Mar 2004 08:48:58 -0700 (MST) From: "scott.marlowe" To: Aldo Leyva Alvarado Cc: =?iso-8859-1?Q?S=F8ren_Bentzen?= , , Subject: Re: FUNCTIONS In-Reply-To: <002701c40c71$3c2e46c0$3c0000c0@pegasus> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-1 Content-Transfer-Encoding: 8BIT X-IHS-MailScanner: Found to be clean X-IHS-MailScanner-SpamCheck: X-IHS-MailScanner-Envelope-Sender: scott.marlowe@ihs.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/50 X-Sequence-Number: 2649 In Postgresql, the number of stored procedures isn't really an issue. however, the efficiency of those stored procedures, and the table schema they operate on is quite important. Make sure your fk/pk relationships are of the same data type. Make sure you aren't writing triggers that wind up being accidentally recursive Stored procedures in C are usually the fastest, but plpgsql and plsql are both quite acceptable performers. I would worry more about database tuning and proper design of the schema than the stored procs. Make as many UDFs (user defined functions, the postgresql name for a stored procedure, sorta) as you want, the number of them won't be an issue. On Wed, 17 Mar 2004, Aldo Leyva Alvarado wrote: > I know that in other DB, if you have many Stored Procedure the perfomance > could be reduce > > Aldo > ----- Original Message ----- > From: "Søren Bentzen" > To: "Aldo Leyva Alvarado" ; "scott.marlowe" > > Cc: ; > Sent: Wednesday, March 17, 2004 4:54 PM > Subject: Re: [PHP] FUNCTIONS > > > > Hi > > Should I understand your question like this one: How many stones are there > > on the moon? > > I am not shure that kind of question can answer with an exact number. I > > presume it depends on factors like disk space, memory space and other > > factors that can be adjusted. I think that a more relevant question could > be > > how big in bytes, a stored procedure can be? > > And why do you want to know that, if the question can be answered? > > > > BR > > Søren > > > > ----- Original Message ----- > > From: "Aldo Leyva Alvarado" > > To: "scott.marlowe" > > Cc: ; > > Sent: Wednesday, March 17, 2004 10:21 PM > > Subject: Re: [PHP] FUNCTIONS > > > > > > > Yes, I know, But I want to know how many STORED PROCEDURE supports > > POSTGRES, > > > maybe 100 or 500 or maybe more. > > > > > > Thanks > > > > > > ----- Original Message ----- > > > From: "scott.marlowe" > > > To: "Aldo Leyva Alvarado" > > > Cc: ; > > > Sent: Wednesday, March 17, 2004 11:22 AM > > > Subject: Re: [PHP] FUNCTIONS > > > > > > > > > > In Postgresql, a stored procedure is created using a user defined > > > > function, and accessed with something simple like: > > > > > > > > select myfunc('arg1','arg2'); > > > > > > > > So, it's just another select statement to PHP/Postgresql. You don't > > have > > > > to do anything fancy to hit a stored procedure. > > > > > > > > On Tue, 16 Mar 2004, Aldo Leyva Alvarado wrote: > > > > > > > > > Thanks, > > > > > but I talked about to STORE PROCEDURE. > > > > > > > > > > > > > > > Aldo Leyva > > > > > > > > > > ----- Original Message ----- > > > > > From: > > > > > To: > > > > > Cc: > > > > > Sent: Monday, March 15, 2004 10:33 PM > > > > > Subject: Re: [PHP] FUNCTIONS > > > > > > > > > > > > > > > > > > > > > > Aldo...... > > > > > > > > > > > > > Can you tell me how many functions supports POSTGRES? > > > > > > > > > > > > I'm not going to count them, but you can total them up and read > all > > > about > > > > > > them in Chapter LXXXIV of the php manual, entitled PostgreSQL > > > Functions. > > > > > > The url is: > > > > > > > > > > > > http://us4.php.net/manual/en/ref.pgsql.php > > > > > > > > > > > > Or another of the mirrors. > > > > > > > > > > > > brew > > > > > > > > > > > > > > > > > > ---------------------------(end of > > > broadcast)--------------------------- > > > > > > TIP 6: Have you searched our list archives? > > > > > > > > > > > > http://archives.postgresql.org > > > > > > > > > > ---------------------------(end of > > broadcast)--------------------------- > > > > > TIP 1: subscribe and unsubscribe commands go to > > majordomo@postgresql.org > > > > > > > > > > > > > > > > > ---------------------------(end of > broadcast)--------------------------- > > > > TIP 1: subscribe and unsubscribe commands go to > majordomo@postgresql.org > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 9: the planner will ignore your desire to choose an index scan if > your > > > joining column's datatypes do not match > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 2: you can get off all lists at once with the unregister command > > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org >