FIX: It may take longer than expected to create a SQL Server LineString instance in SQL Server 2014 SP1

Van toepassing: SQL Server 2014 DeveloperSQL Server 2014 DeveloperSQL Server 2014 Enterprise


To enable the new behavior, enable the SQL Server trace flag 6534.

The issue was first fixed in the following cumulative update of SQL Server.

Cumulative Update 8 for SQL Server 2012 SP2

Cumulative Update 9 for SQL Server 2014

Cumulative Update 1 for SQL Server 2014 SP1

More Information

The Microsoft.SqlServer.Types objects support Microsoft SQL Server Spatial data types for the SQL Server service and the client applications. The logic to populate a LineString object involves validation. The validation logic sorts vertices during the validation. The more vertices, the more work for the algorithm. This fix updates the sorting algorithm to include angular vectorization techniques that significantly improve the LineString performance.

You can enable the new algorithm in client code:
AppDomain.CurrentDomain.SetData("clr_feature_switch_map", 1);
Note This should only be set for one time. A crash may occur when you change it during the validation.


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.