This project has moved and is read-only. For the latest updates, please go here.

Many ".Include"'s yields 5 minute query time or longer.

Jul 20, 2016 at 4:37 PM
I am trying to do some unit tests where I have the following:
        investment = db.Investment
            .Include(e => e.Positions.Select(p => p.Transactions))
            //.Include(e => e.Positions.Select(p => p.InvestmentCarry))
            .Include(e => e.RelatedInvestments)
            .Include(e => e.PrivateInvestment)
            .Include(e => e.CoInvestment)
            .FirstOrDefault(e => e.Id == id)
The time it takes for Effort to execute this is 5 or more minutes. I have another LINQ query that is similar that takes 14 minutes on our build server.

Any ideas? Does Effort need to be adjusted somehow? Maybe I need to reconsider how I've set up my query, although in a database environment it executes quickly.

Any suggestions?
Oct 31, 2016 at 2:41 PM
Edited Oct 31, 2016 at 2:42 PM
Anyone figure out a solution for this? Having same issue. Single include works fine. Adding a second include times out. Either seems like a major limitation of the library or else we're doing something incorrectly. Either way would be nice to document a solution.