This discussion is archived
1 Reply Latest reply: Nov 19, 2012 4:06 AM by 792937 RSS

OCICollAppend has performance issue in my test

792937 Newbie
Currently Being Moderated

I am doing a program which will pass an Type Array as input parameter to oracle. In one case, there is a input parameter which has an type array with 5000 Type objects.

I construct the object one by one and pass the object to the OCICollAppend, finally in my test, I fount oci doing the 5000 OCICollAppend takes about 120 seconds to finish.

Is there an other way to optimize the performance of pass Type Array by OCI?


Edited by: Bruce on 2011-4-13 下午11:28


  • Correct Answers - 10 points
  • Helpful Answers - 5 points