JSON parsing 10x faster than XML parsing

added by DotNetKicks
11/13/2017 3:54:49 PM

2 Kicks, 278 Views

Usually, when people talk about the performance of JSON in SQL Server, they are starting with "JSON is not actually a native type, it is just a plain text" and imply that it is probably too slow. It is true that JSON is stored as NVARCHAR and that there is no special type like for XML or Spatial.