1 2 Previous Next 22 Replies Latest reply on May 15, 2012 10:10 PM by rp0428

    Reg:Select during Bulk Insert  causing performance degradation

    user887416
      Hi All,

      I need to insert large volumes of data into my database during which i need to validate the data using the previous record of the consumer.
      For this i am creating multiple threads each of which commits for every 1000 records. I am fetching the previous record and validating the data before inserting it.
      How this is select query for fetching the previous records during the insertion degrades the performance. I think this bulk insert is causing the table locks due to which the performance is degrading.

      Can someone help me in resolving this problem???

      Regards
      Murali
        1 2 Previous Next