1 Reply Latest reply: Nov 19, 2012 6:06 AM by 792937 RSS

    OCICollAppend has performance issue in my test

    792937
      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