re: Entity Framework Core performance tuning–Part III

Oct 10 2017

reEntity Framework Core performance tuning–Part III

time to read 1 min | 166 words

I mentioned in the previous post that I’ll take the opportunity to show of some interesting queries. The application itself is here, and you can see how to UI look in the following screenshot:

I decided to see what would be the best way to come up with the information we need for this kind of query. Here is what I got.

This is using a select object style to get a complex projection back from the server. Here are the results:

As you can see, we are able to get all the data we want, in a format that is well suited to just sending directly to the UI with very little work and with tremendous speed.

Tweet Share Share 4 comments

Tags:

More posts in "re" series:

(12 Nov 2019) Document-Level Optimistic Concurrency in MongoDB
(25 Oct 2019) RavenDB. Two years of pain and joy
(19 Aug 2019) The Order of the JSON, AKA–irresponsible assumptions and blind spots
(10 Oct 2017) Entity Framework Core performance tuning–Part III
(09 Oct 2017) Different I/O Access Methods for Linux
(06 Oct 2017) Entity Framework Core performance tuning–Part II
(04 Oct 2017) Entity Framework Core performance tuning–part I
(26 Apr 2017) Writing a Time Series Database from Scratch
(28 Jul 2016) Why Uber Engineering Switched from Postgres to MySQL
(15 Jun 2016) Why you can't be a good .NET developer
(12 Nov 2013) Why You Should Never Use MongoDB
(21 Aug 2013) How memory mapped files, filesystems and cloud storage works
(15 Apr 2012) Kiip’s MongoDB’s experience
(18 Oct 2010) Diverse.NET
(10 Apr 2010) NoSQL, meh
(30 Sep 2009) Are you smart enough to do without TDD
(17 Aug 2008) MVC Storefront Part 19
(24 Mar 2008) How to create fully encapsulated Domain Models
(21 Feb 2008) Versioning Issues With Abstract Base Classes and Interfaces
(18 Aug 2007) Saving to Blob
(27 Jul 2007) SSIS - 15 Faults Rebuttal
(29 May 2007) The OR/M Smackdown
(06 Mar 2007) IoC and Average Programmers
(19 Sep 2005) DLinq Mapping

Comments

10 Oct 2017
10:42 AM

Uri

Amazing performance, where the source can be found? any chance to publish this on GitHub?

10 Oct 2017
10:47 AM

Oren Eini

Uri, The entire thing is in the post. There isn't anything beyond it. The code for the data is actually from here: https://github.com/JonPSmith/EfCoreInAction

10 Oct 2017
11:58 AM

Dejan Miličić

How this query would look like in method-chain LINQ notation?

10 Oct 2017
12:29 PM

Oren Eini

Dejan, Something like this:

from result in session.Query<Books_Search.Result, Books_Search>()
where result.PublishedOn > min && result.PublishedOn < max)
orderby result.VotesAverage descending
let b = session.Load<Book>(result.BookId)
select new 
{
    result.VotesVerage,
    result.VotesTotal,
    results.PublishedOn,
    b.Title,
    Authors = b.Authors.Select(x=>x.Name)   
};

Comment preview

Comments have been closed on this topic.

Ayende @ Rahien

Ayende @ Rahien