0 Replies Latest reply: Nov 19, 2012 5:55 AM by 792937 RSS

    OCIObjectSetAttr performance deteriorates when binding too many Type params

    792937
      Hi,

      In my application, when I passed a Type Array as parameter to the stored procedure and when the Type Array is large enough(normally 3000 type objects, each objects has about 15 attributes), the OCIObjectSetAttr performance deteriorates large enough from below 1 millisecond to 1~3 miliseconds.

      I am using OCI 11gR2, does anyone notice it and know how to optimize it?

      Regards,
      -Bruce