RE: Set Triggers Disabled and 4GL

This is not just for the session - it is going to affect all users. I also think you will need exclusive access to the table to do this, so if someone else is using the table, you might not be able to do it. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Nsvirk Sent: 11 October 2005 12:40 AM To: informix-list@iiug.org Subject: Set Triggers Disabled and 4GL All , I have a situation where I need to update a date in a table . However the table has an update trigger which calls three stored procedures . As the no of updates is to the order of 200000 daily , the trigger is causing the updates to be extermely slow . I am planning to "set triggers for table disabled" using 4GL by preparing and executing it and enabling them when the program ends.. Will this statement cause the triggers to be disabled for the session or the user or will it disable the trigger for all sessions and users (this would not be a desirable situation). Is there any other strategy to avoid the performance hit because of the trigger firing . NSV sending to informix-list sending to informix-list