I found this link from IBM DB2 developers showing why PERSISTENT PREPARE
is a good idea and how could it be implemented.
It seems that main benefit (beside efficiency) is memory.
Having number of connections all with dozens of PREPARED statements
consumes lot of memory.
If we put these statements in global space (perhaps not even in RAM
memory until needed) we could reuse optimization plans as well as
physical space needed to store them.
I also found articles:
all about users trying to explain PERSISTENT PREPARE (some refer to it
as global prepare).
There are also some guys who actually made some code for PERSISTENT PREPARE:
PEOPLE NEED THIS FEATURE !!! It is not discovering the wheel but it will
simplify DB programming and even gain some performance.
NONE OF POPULAR SQL DBMS (Oracle, MS SQL, MySQL, Postgre, INTERBASE,
FIREBIRD) HAVE THIS FEATURE.
In response to
pgsql-sql by date
|Next:||From: Craig Ringer||Date: 2008-07-22 01:04:41|
|Subject: Re: PERSISTANT PREPARE (another point of view)|
|Previous:||From: Emi Lu||Date: 2008-07-21 16:59:02|
|Subject: Re: Size or efficiency differences "varchar(128) vs. varchar(32)"|