Sign in to confirm you’re not a bot
This helps protect our community. Learn more

.NET Data Community Standup - Performance Improvements to the EF7 Update Pipeline

dotnet
324K subscribers
<__slot-el>
<__slot-el>
7.3K views Streamed 2 years ago #ef #efcore
Join the Entity Framework team as they review optimizations to the update pipeline to improve performance. Come prepared with your EF7 questions as we plan to spend time in Q&A to answer your questions live. Community Links: https://www.theurlist.com/dotnet-data... Featuring: Arthur Vickers (@ajcvickers), Shay Rojansky (@shayrojansky) Get your questions answered on the Microsoft Q&A for .NET - https://aka.ms/dotnetqa ​ Learn .NET with free self-guided learning from Microsoft Learn: http://aka.ms/learndotnet #efcore #ef #efperformance ...more
...more
These chapters are auto-generated

Countdown

0:00

Introduction

2:34

Presentation

6:17

Model

11:42

SQL

12:02

Single Cell Insert

13:59

Round Trips

18:59

Round Trip Example

22:02

BenchmarkNet

24:17

dbContextPooling

26:05

Running the code

30:24

Running on the command line

30:40

Warmup phase

30:51

Benchmark

31:18

Command Line Release Mode

31:57

Local vs localhost

32:18

Results

32:59

Running on a laptop

33:15

Disclaimer

33:54

Jeremy

34:14

Postgres Optimization

37:20

Dapper

40:37

Using Dapper

42:50

Update and Delete

43:51

Why do we benchmark

45:17

Computer specs

46:34

Second optimization

47:12

Scenario

47:53

Round Trip

48:12

EF7 SQL

48:28

EF7 IF71

48:39

EF7 SQL Server Provider

49:15

Postgres Merge

49:25

What is Merge

49:39

Merge into Table Blocks

49:56

Advantages of EF Core

50:58

Inserted Zero

52:12

Benchmarking

53:00

Single Rows

54:11

Four Rows

55:14

Why is it so slow

55:28

Overhead

55:37

Merge

55:49

Triggers

56:38

Theory

57:30

Exception

59:49
.NET Data Community Standup - Performance Improvements to the EF7 Update Pipeline
Join the Entity Framework team as they review optimizations to the update pipeline to improve performance. Come prepared with your EF7 questions as we plan to spend time in Q&A to answer your questions live. Community Links: https://www.theurlist.com/dotnet-data... Featuring: Arthur Vickers (@ajcvickers), Shay Rojansky (@shayrojansky) Get your questions answered on the Microsoft Q&A for .NET - https://aka.ms/dotnetqa ​ Learn .NET with free self-guided learning from Microsoft Learn: http://aka.ms/learndotnet #efcore #ef #efperformance

Follow along using the transcript.

dotnet

324K subscribers