The Update Subnetworks tool is very slow in the step to remove subnetwork names.

Workaround

There are no workarounds, but possible solutions include:

• Alter SQL to take advantage of the FULLTEXT index. For example, for SQL Server, this requires the use of the CONTAINS keyword.
• Provide a mode that does not remove the subnetwork names from the assets. This is useful for the initial run of the Update Subnetworks tool following data migration.
• Provide a subnetwork setting (and corresponding implementation of the Remove Subnetwork Names step) that assumes all asset subnetwork name values are single rather than a list separated by '::'. For this particular sewer solution issue, the subnetwork lists do not occur.

Steps to Reproduce