Huge Memory Issue in Entity framework Load Method

Question

Huge Memory Issue in Entity framework Load Method

Indudhar Gowda 426

 this.Context.TestPRepetitions.Where(tp => sampleCodes.Contains(tp.SampleCode))  
                .Include(tp => tp.ReportableResults)  
                .Load();  
  
 this.Context.Recognitions.Where(rec => reportableResultIds.Contains(rec.ReportableResultId)).Load();

Recognitions Table has 6352014 Rows

@AgaveJoe this what the Actual Method Does...

Karen Payne MVP 35,596 Reputation points Volunteer Moderator

2022-05-04T17:41:24.883+00:00

In regards to memory leakage, don't use one DbContext for all your work, create a context for each operation with a using statement. Concerning using Contains, is the column properly indexed? Have you used SQL-Server Profiler?

Also see the following post.
AgaveJoe 30,491 Reputation points

2022-05-04T18:27:12.417+00:00

Perhaps you don't need to copy so much data from the database to C#? What are you doing with the data that requires C#?
Indudhar Gowda 426 Reputation points

2022-05-04T19:13:39.423+00:00

@AgaveJoe : I need to stop Memory Issue in SearchSamples Method.
Indudhar Gowda 426 Reputation points

2022-05-04T19:14:08.927+00:00

@Karen Payne MVP : I need to stop Memory Issue in SearchSamples Method.
Karen Payne MVP 35,596 Reputation points Volunteer Moderator

2022-05-04T19:28:42.047+00:00

Well that is a given, please answer my questions.

1 answer

Your answer

Karen Payne MVP 35,596 Reputation points Volunteer Moderator

2022-05-04T17:41:24.883+00:00

In regards to memory leakage, don't use one DbContext for all your work, create a context for each operation with a using statement. Concerning using Contains, is the column properly indexed? Have you used SQL-Server Profiler?

Also see the following post.
AgaveJoe 30,491 Reputation points

2022-05-04T18:27:12.417+00:00

Perhaps you don't need to copy so much data from the database to C#? What are you doing with the data that requires C#?
Indudhar Gowda 426 Reputation points

2022-05-04T19:13:39.423+00:00

@AgaveJoe : I need to stop Memory Issue in SearchSamples Method.
Indudhar Gowda 426 Reputation points

2022-05-04T19:14:08.927+00:00

@Karen Payne MVP : I need to stop Memory Issue in SearchSamples Method.
Karen Payne MVP 35,596 Reputation points Volunteer Moderator

2022-05-04T19:28:42.047+00:00

Well that is a given, please answer my questions.

Answer 1

Bruce (SqlWork.com) 82,146 Volunteer Moderator

Don’t use Load(). It’s whole point is to load all the rows into memory, and uses lots of memory.

Indudhar Gowda 426 Reputation points

2022-05-05T03:05:28.863+00:00

What's the alternative solution for load looking at the above method
Indudhar Gowda 426 Reputation points

2022-05-05T03:08:05.957+00:00

Can I write a sql query for searchsample method
Jack J Jun 25,316 Reputation points

2022-05-05T09:20:50.867+00:00

@Indudhar Gowda , yes, you can write a sql query for searchsample method, but according to your code it will be a bit complexity. BTW, please refer to use Raw SQL Queries to replace using ADO.NET to query the database.

Share via

Huge Memory Issue in Entity framework Load Method

1 answer

Your answer