how to parse only once for multiple executions of the same statment

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
hpalacio
Posts: 6
Joined: Fri 17 Mar 2006 15:29

how to parse only once for multiple executions of the same statment

Post by hpalacio » Fri 17 Mar 2006 15:47

Is there a way to parse a statement only once for multiple executions of the same statement? I have an insert statement that I use multiple times in a single transaction and have found in the trace file that it is parsed once for each time that it is called.

This is a serious issue because this could cause severe slowdowns in our production system where the statement is likely to be called several thousand times.

Any help would be greatly appreciated!

-HP

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Mon 20 Mar 2006 07:03

Please use OracleCommand.Prepare() method before command execution

Post Reply