For better performance, try to utilize prepared statements;
example:
PREPARE CPrep_Clients (varchar(20)) AS SELECT * FROM client WHERE nom = $1;
EXECUTE CPrep_Clients('Francio');
In my system, over 51ms difference between standard select (prepared
by-passplanification/optimization)
Regards
> ----- Original Message -----
> From: <alex-lists-pgsql@yuriev.com>
> To: <pgsql-sql@postgresql.org>
> 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 procedure?
>>
>> Alex
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 4: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>>
>>
>
