1 Reply Latest reply on Nov 19, 2012 12:06 PM by 792937

    OCICollAppend has performance issue in my test


      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