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

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

Postby 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
hpalacio
 
Posts: 6
Joined: Fri 17 Mar 2006 15:29

Postby Paul » Mon 20 Mar 2006 07:03

Please use OracleCommand.Prepare() method before command execution
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06


Return to dotConnect for Oracle