Re: Puzzling "Costly type conversion" warnings
Posted by: Craig Carper
Date: June 10, 2005 10:49PM

Mark Matthews wrote:
[snip]
...
> Nope. Not true. You can only have one open result
> set per statement, but you can have as many open
> statements on a connection as you need.

Thanks for pointing out that multiple statements can co-exist on a connection. Habits can turn into false assumptions.

Still, its not obvious how to use prepared statements to improve performance in a web application that grabs a connection for each request and isn't likely to execute the same statement twice in handling a single request. Seems a shame that a new connection can't benefit from an identical prepared statement on an earlier connection.

Options: ReplyQuote


Subject
Written By
Posted
Re: Puzzling "Costly type conversion" warnings
June 10, 2005 10:49PM


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.