Thread: Re: [GENERAL] Prepared statement performance...

Re: [GENERAL] Prepared statement performance...

From
"Shridhar Daithankar"
Date:
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
backenditself 
> 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