The benchmarking results and their analysis

Before we analyze the results, it is worth noting some big data statistics from 2020. Google gets more than 40,000 queries per second. This equates to 3,456,000,000 queries per day. There are 65,000,000,000 WhatsApp business app messages sent per day. In the course of 24 hours, there are 1,440 minutes, which is 86,400 seconds, which is 86,400,000 milliseconds.

Here is our benchmark summary report:

Figure 11.1 – Data access benchmark summary

Let's discuss the insert statements first. The results are as follows:

• InsertProductDDNSP = 1.841 ms
• InsertProductADNSP = 1.894 ms
• InsertProductDDN = 2.058 ms
• InsertProductADN = 2.092 ms
• InsertProductEF = 2.196 ms
• InsertProductEFSP = 396.509 ms

From the summary, we can see that the best-performing insert statement is the Dapper.NET stored procedure insert, taking approximately 1.841 ms to execute, followed by InsertProductADNSP...