Re: Prepared statement performance...

On 25 Sep 2002 at 11:14, Dmitry Tkach wrote:

> Hi, everybody.
> 
> I am running into huge performance problems, due to JDBC not being able to cache query plans :-(
> My java program runs the (set of about 5) identical statements with different parameters for about 30 million times...
> What I am talking about below has to do with JDBC, but is not really specific to it - it seems to me, that the backend itself
> could be improved to better handle this kind of scenario, when the same statement is executed many times in the same session.

> - a general solution, that would involve extending postgres SQL gramma to include a 'prepare' statement

Added in upcoming 7.3.. So youmight want to test the betas or CVS..

Just wondering.. Would you see any performance difference in case you put the 
statements in pl/pgsql functions?

 Just a thought..

Bye
 Shridhar

--
The Sixth Commandment of Frisbee:	The greatest single aid to distance is for 
the disc to be going in a	direction you did not want.   (Goes the wrong way = 
Goes a long way.)		-- Dan Roddick