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