JSON parsing is faster than Spatial equivalent

added by DotNetKicks
11/14/2017 3:23:16 PM

1 Kicks, 275 Views

One of the most common assumption when people talk about JSON in SQL Server is that it is slow because it is placed in "plain text" and there is no native type. Instead of the assumption it is better to experiment and compare performance of JSON with some real native type.