Code used to reproduce a memory issue in EntityFramework
Performance issue
- ID 1 = 20mb
- ID 2 = 40mb
- ID 3 = 60mb
- ID 4 = 80mb
- ID 5 = 100mb
What we can clearly see is that find without running the async method, it takes between 150 to 350ms, but async are taking between 13000ms to 280000ms
Memory Issue
- With 2 mb binary data Find uses about 52 mb
- With 2 mb binary data FindAsync uses about 96 mb
- With 20 mb binary data Find uses about 63 mb
- With 20 mb binary data FindAsync uses about 432 mb