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
Hi,

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?

Regards,
-Bruce

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

Legend

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