Re: Set Triggers Disabled and 4GL

I think an statement like this affects all users and sessions. If that's the case you can re-enable them later after your process has finished. J. Nsvirk escribis: > 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