Querying Json Recursively in Azure SQL Database

Reblogged of an interesting summary of querying json in SQL Azure Querying Json Recursively in Azure SQL Database.

Advertisements

Low performance recognition: a new start?

While we have achieved great performance gains in other areas, .NET still lags behind other platforms in data access benchmarks.

As an example, the TechEmpower Fortunes benchmark shows similar numbers across raw ADO.NET, Dapper and EF Core variations: throughput flatlines or even decreases as concurrent requests increase, which seems to indicate that bottlenecks are preventing efficient hardware utilization.

The performance of accessing databases using .NET should be much more competitive, and we (several people from Microsoft and the .NET developer community) are going to do something about it.

via GitHub – aspnet/DataAccessPerformance: Benchmarks, prototypes and discussions for database access performance investigation