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