Results 1 to 1 of 1
  1. #1
    Join Date
    Jul 2011
    Posts
    16

    Unanswered: Problem in Insert queries on table having triggers on it.

    I have 2 tables(Master and Child) which have primary and foreign key relationship. A trigger is applied on the Master table which inserts data into some Back up table. Also before the delete is performed on the Master and Child table the foreighn key constraint is removed and then a delete is performed for both the tables and then a commit is done.This delete is performed as the first step to clear the dB.All these thinmgs are done in ESQL code in Message Broker tool kit.

    When I am passing small input to the Message Broker Flow which insert 100-200 rows in the table the complete operation is done in 1 min. But when I pass a bulk input which inserts some 80,00 rows it takes 2 hours.

    When the triggers is removed from the Master table same bulk input when it is passed it inserts 80,000 records in 5 mins.

    What can be the problem and how can I rectify it.

    Thanks,
    Last edited by pratikp.vasani; 03-12-12 at 08:53.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •