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:

(19 Jun 2024) Building a Database Engine in C# & .NET
(05 Mar 2024) Technology & Friends - Oren Eini on the Corax Search Engine
(15 Jan 2024) S06E09 - From Code Generation to Revolutionary RavenDB
(02 Jan 2024) .NET Rocks Data Sharding with Oren Eini
(01 Jan 2024) .NET Core podcast on RavenDB, performance and .NET
(28 Aug 2023) RavenDB and High Performance with Oren Eini
(17 Feb 2023) RavenDB Usage Patterns
(12 Dec 2022) Software architecture with Oren Eini
(17 Nov 2022) RavenDB in a Distributed Cloud Environment
(25 Jul 2022) Build your own database at Cloud Lunch & Learn
(15 Jul 2022) Non relational data modeling & Database engine internals
(11 Apr 2022) Clean Architecture with RavenDB
(14 Mar 2022) Database Security in a Hostile World
(02 Mar 2022) RavenDB–a really boring database

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.

Oren Eini

Oren Eini

CEO of RavenDB