We are using NAV2017. We are facing some performance issues which is traced to Workflow subscriber events. Is there a way to disable Event Subscribers apart from making modifications directly into the Event Subscriber codeunit?
you can turn off the events in the "Events subscription" Page.
The page is non editable, and the table this page refers to is a virtual table. There is no way to turn it off on this page. At least in NAV2017 this is not possible.
Ability to disable/enable events on-the-fly will create a TOTAL MESS in NAV data.
I understand. I am not turning off events, but I am disabling the subscriptions to these events. As some of these subscriptions to these evetns are causing performance issues. E.g. in workflow, when a GenJnlLine is deleted, it performs a check on a table. Imagine, if 50,000 lines are posted in GenJnlLine, this check is done 50,000 times. And not to mention, if there is a subscription, (I think...) it also disables the SQL bulk delete feature, and delete is sent to SQL sequentially 50,000 times.
Comments
The page is non editable, and the table this page refers to is a virtual table. There is no way to turn it off on this page. At least in NAV2017 this is not possible.
I understand. I am not turning off events, but I am disabling the subscriptions to these events. As some of these subscriptions to these evetns are causing performance issues. E.g. in workflow, when a GenJnlLine is deleted, it performs a check on a table. Imagine, if 50,000 lines are posted in GenJnlLine, this check is done 50,000 times. And not to mention, if there is a subscription, (I think...) it also disables the SQL bulk delete feature, and delete is sent to SQL sequentially 50,000 times.