Click here to Skip to main content
15,438,920 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: ASP.NetCore Freeze the header of html table Pin
pkfox25-Feb-22 2:31
professionalpkfox25-Feb-22 2:31 
Questionselect data from two table of database based on one column of excel data which is uploaded . Pin
Member 1449552212-Feb-22 23:36
MemberMember 1449552212-Feb-22 23:36 
AnswerRe: select data from two table of database based on one column of excel data which is uploaded . Pin
Richard Deeming14-Feb-22 3:46
mveRichard Deeming14-Feb-22 3:46 
AnswerRe: select data from two table of database based on one column of excel data which is uploaded . Pin
RedDk14-Feb-22 7:53
MemberRedDk14-Feb-22 7:53 
QuestionAsp.Net Core. Sending requests with Postman. Pin
Kamil Kluska5-Feb-22 22:47
MemberKamil Kluska5-Feb-22 22:47 
AnswerRe: Asp.Net Core. Sending requests with Postman. Pin
Richard MacCutchan6-Feb-22 0:28
mveRichard MacCutchan6-Feb-22 0:28 
QuestionWhich one of the following codes has better performance in ASP.NET Core? Pin
Alex Dunlop4-Feb-22 21:05
MemberAlex Dunlop4-Feb-22 21:05 
AnswerRe: Which one of the following codes has better performance in ASP.NET Core? Pin
Afzaal Ahmad Zeeshan5-Feb-22 3:27
mveAfzaal Ahmad Zeeshan5-Feb-22 3:27 
EF Core is smart enough to run the ToList after the entire SQL query has been built. I am guessing the GetAllMessages part applies the filtering to the query as well; if so, they're the same in the same query builder. You need to understand two parts here. First, EF Core builds a single query that is sent to the database engine. The fluent way to build a query helps you apply all sorts of ORDER BYs and WHEREs to the SQL query; including any JOINs. Then, the database query planner kicks in and prepares how to capture the data. Database query plan will always try to find the optimum way to execute the SQL commands and return the results.

Since query plans are highly based on databases themselves, I would link a Wikipedia article: Query plan - Wikipedia, you can search for the documentation per your database engine.

Now, the performance would take a toll if you are filtering on the server side and not on the database side. What I mean is, that you capture the list of the records from the database and then filter them in the memory of the server process. Boy, that'd hurt a lot.

Applies to modern async-based EF-only: Finally, the performance can be improved (in terms of number of requests per second) if you would use ToListAsync() instead of ToList(), where the later is a synchronous operation and would block the thread.

DbContext Lifetime, Configuration, and Initialization - EF Core | Microsoft Docs
Efficient Querying - EF Core | Microsoft Docs
Performance Diagnosis - EF Core | Microsoft Docs
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~

QuestionWhat to use for a job scheduler for a .net app with plugins for each job Pin
jumbojs29-Jan-22 3:39
Memberjumbojs29-Jan-22 3:39 
AnswerRe: What to use for a job scheduler for a .net app with plugins for each job Pin
Bohdan Stupak4-Feb-22 4:42
professionalBohdan Stupak4-Feb-22 4:42 
QuestionInitial design question on an ASP.NET Core MVC project. Pin
nstk20-Jan-22 9:21
Membernstk20-Jan-22 9:21 
Questionasp.net Pin
Member 1449552218-Jan-22 0:18
MemberMember 1449552218-Jan-22 0:18 
AnswerRe: asp.net Pin
Richard Deeming18-Jan-22 1:44
mveRichard Deeming18-Jan-22 1:44 
QuestionError NETSDK1045 The current .NET SDK does not support targeting .NET Core 2.2 Pin
Member 1547980726-Dec-21 3:52
MemberMember 1547980726-Dec-21 3:52 
AnswerRe: Error NETSDK1045 The current .NET SDK does not support targeting .NET Core 2.2 Pin
OriginalGriff26-Dec-21 3:53
mveOriginalGriff26-Dec-21 3:53 
AnswerRe: Error NETSDK1045 The current .NET SDK does not support targeting .NET Core 2.2 Pin
Mycroft Holmes26-Dec-21 11:45
professionalMycroft Holmes26-Dec-21 11:45 
GeneralRe: Error NETSDK1045 The current .NET SDK does not support targeting .NET Core 2.2 Pin
Member 1547980726-Dec-21 18:21
MemberMember 1547980726-Dec-21 18:21 
QuestionHttps redirection modifies url path Pin
Member 1547511221-Dec-21 1:10
MemberMember 1547511221-Dec-21 1:10 
AnswerRe: Https redirection modifies url path Pin
Richard Deeming4-Jan-22 0:26
mveRichard Deeming4-Jan-22 0:26 
QuestionHow to fill Foreign Key in a relational database when creating a new row? Pin
Alex Dunlop19-Dec-21 7:12
MemberAlex Dunlop19-Dec-21 7:12 
AnswerRe: How to fill Foreign Key in a relational database when creating a new row? Pin
Alex Dunlop19-Dec-21 8:02
MemberAlex Dunlop19-Dec-21 8:02 
QuestionWhere did i get asp.net project in linux with mysql database.? Pin
Tushar Surve 202115-Dec-21 6:11
MemberTushar Surve 202115-Dec-21 6:11 
AnswerRe: Where did i get asp.net project in linux with mysql database.? Pin
Richard Deeming15-Dec-21 6:22
mveRichard Deeming15-Dec-21 6:22 
GeneralRe: Where did i get asp.net project in linux with mysql database.? Pin
Mycroft Holmes15-Dec-21 13:31
professionalMycroft Holmes15-Dec-21 13:31 
QuestionTwo ReportViewers on the same project Pin
Member 1077312213-Dec-21 1:01
MemberMember 1077312213-Dec-21 1:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.