I already checked the speed without triggers and I have a big performance improvement.
What I want to do is temporarily disable the trigger in my code before I do my processing, do my processing and then re-create the triggers.
Thanks
Eric Dumais
>Hi Eric,
>
>What are you looking for? Do you want to check the speed without any triggers?
>
>>Hi everyone.
>>
>>I want to temporarily "deactivate" the triggers on tables for performance reasons.
>>
>>I know about the DELETE TRIGGER and CREATE TRIGGER commands. What I cannot seem to find is a function that will return me the current value of the trigger. What I want to do is store the triggers in a temporary table, delete them, do my processing and then re-set the triggers based on what I have in the temporary table.
>>
>>Maybe this is not the right way to go, if someone have a suggestion, feel free to give me your input.
>>
>>Thanks in advance.
>>
>>Eric Dumais.
ERIC DUMAIS