Skip site navigation (1) Skip section navigation (2)

Re: PERSISTANT PREPARE (another point of view)

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: milan(dot)opa(at)gmail(dot)com, pgsql-sql(at)postgresql(dot)org
Subject: Re: PERSISTANT PREPARE (another point of view)
Date: 2008-07-22 02:31:13
Message-ID: 48854671.6040208@postnewspapers.com.au (view raw or flat)
Thread:
Lists: pgsql-sql
Earlier, I wrote:

> Exactly what is gained by the use of persistent prepare over the use of 
> a stored procedure?

Er, ENOCOFFEE. Sorry.

The benefit is obvious with use of global prepared statements at the 
wire protocol level rather than via SQL EXECUTE . It's a lot more 
efficient than EXECUTE or SELECT function(params).

It's pretty clear that there are some tricky aspects though, what with 
schema search paths, role priveleges, etc.

--
Craig Ringer

In response to

pgsql-sql by date

Next:From: Pavel StehuleDate: 2008-07-22 06:43:41
Subject: Re: PERSISTANT PREPARE (another point of view)
Previous:From: Craig RingerDate: 2008-07-22 01:04:41
Subject: Re: PERSISTANT PREPARE (another point of view)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group