Sunday, July 13, 2008

[PERFORM] Trigger is not firing immediately

 
Hi All,
    I am having a trigger in table, If I update the the table manually trigger is firing immediately(say 200ms per row), But if I update the table through procedure the trigger is taking time to fire(say 7 to 10 seconds per row).
 
Please tell me what kind of changes can I make so that  trigger  fire immediately while updating the table through procedure ?
 
Regards,
Praveen

No comments: