From: ipv@tinet.org
To: pgsql-sql@postgresql.org
Subject: Fw: stored procedures for complex SELECTs
Date: Wed, 25 Jan 2006 04:01:07 +0100
Message-ID: <003901c6215b$97036340$0600000a@matt.mutua> (raw)
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-pass
planification/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
>>
>>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ipv@tinet.org
Subject: Re: Fw: stored procedures for complex SELECTs
In-Reply-To: <003901c6215b$97036340$0600000a@matt.mutua>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox