This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 90%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
I have a query which calls Load() after and it takes forever. Is there anyway I can optimize it. Below is my query
var EmpUsers = data.DeptRoles
.Include(x => x.ROLE)
.Include(x => x.USER)
.Where(x => x.Id == deptId && x.USER.Inactive == false);
EmpUsers.Load(); -----> this takes forever
@Benjoe , Welcome to Microsoft Q&A, I am not full understand your meaning. what is your type of EmpUsers. is it a collection? Where is the Load method?
The Linq query is included in the question.
var EmpUsers = data.DeptRoles
.Include(x => x.ROLE)
.Include(x => x.USER)
.Where(x => x.Id == deptId && x.USER.Inactive == false);
I am calling the Load method on the query and the query is a collection
EmpUsers.Load();
I have figured out the reason. The USER table is huge so I am going to load the query in pieces instead of one query.
How long is "takes forever"? How many records are returned? Can you provide the table schema and/or entity design? Maybe you need to add an index on the DeptRoles table?
I have fixed the issue myself.
var EmpUsers = data.DeptRoles;
var roles = EmpUsers .Include(x => x.ROLE);
var newUsers = roles.Include(x => x.USER)
.Where(x => x.Id == deptId && x.USER.Inactive == false);
newUsers.Load();