Re: The performance problem of server side PreparedStatement?
Posted by: Mark Matthews
Date: December 14, 2004 08:37PM

Li,

Notice that it says it caches the _parsing_ stage only (which only makes sense for emulated prepared statements)

It's much more complex (and usually not worthwile) to cache server-side prepared statements with the driver. It's better to either make sure your application _correctly_ uses prepared statements and uses them in a long-lived manner, or use a connection pool that can cache statements.

The server-side prepared statement implementation in the server is new, and doesn't do anything besides cache the parse stage, and allow more efficient sending and retrieval of parameters and results. It does not cache execution plans.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.