Re: [JDBC] Prepared statement performance...

Dmitry Tkach wrote:
>
> I have to disagree with that too, based on my experience...
> In that application I mentioned in the topic that initiated this
> discussion, the statement, that I have to execute about 30 million times
> looks like
>
> "select * from foo where primary_key=bar"
>
> What could possibly be simpler than that? :-)
> I was surprised to find out however, that in the end the backend turns
> out to have *more* time parsing and planning that query then actually
> executing it :-(
>

I don't disagree that this is a simple query. But remember that since
the implementation of server side prepare is through the sql interface
with each call to execute this statement you still need to issue the
following sql statement: execute <name>(bar); which will still need to
invoke the parser. Using server side prepared statements doesn't
eliminate all parses. It isn't true that you can just take the original
execute time of a statement and assume that with server side prepared
statements the total time will be the same as that, it will be more.

Executing something 30million times will certainly make even a little
improvement for a simple statement like this noticable, but 30million
executes of the same statement certainly isn't the norm. And I would
suggest it is the type of environment where serverside prepared
statements are the most useful. I hope you can try the new
functionality and provide us all with real numbers as to how much it helps.

thanks,
--Barry