Fw: [SQL] stored procedures for complex SELECTs

2006-01-24 Thread ipv
timization) Regards - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Thursday, January 19, 2006 12:17 AM Subject: [SQL] stored procedures for complex SELECTs Are there performance advantages that can be achieved by wrapping a complex SELECT into a stored

Re: [SQL] stored procedures for complex SELECTs

2006-01-18 Thread Michael Glaesemann
On Jan 19, 2006, at 8:17 , [EMAIL PROTECTED] wrote: Are there performance advantages that can be achieved by wrapping a complex SELECT into a stored procedure? I believe it depends on the procedural language. If it's SQL, I think it may be inlined, so you'd have overhead due to the stored p

[SQL] stored procedures for complex SELECTs

2006-01-18 Thread alex-lists-pgsql
Are there performance advantages that can be achieved by wrapping a complex SELECT into a stored procedure? Alex ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org