Filters with a large amount of excluded filters defined are slow to open and cause policies using them to be slow as well.
This can be seen when opening a Task, Managed Delivery, Agent Plugin etc.
This is working as designed as the product is designed to resolve targets before loading the item that uses it.
There are two options:
Option One: This is the simpler approach, however, it should be noted that this also changes the default behavior. After changing this setting targets will only update when the "Delta Resource Membership Update" (under SMP Console>Settings>Notification Server>Resource Membership Update) runs. Meaning that when a policy, task etc is opened the targeted resource list is only as accurate as the last membership update.
The query below can be used to see filters that have multiple exclusions defined. These can then be altered to be an SQL filter or other means to limit the number of exclusions being used.
select c.Name, count (distinct cec.SubCollectionGuid), c.Guid from CollectionExcludeCollection cec join vCollection c on c.Guid = cec.CollectionGuid where c.Attributes = 0 group by c.Name, c.Guid having count (distinct cec.SubCollectionGuid) > 5 order by count (distinct cec.SubCollectionGuid) desc