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.