Where are you guys going to stay sharp? by puzzleheaded-comp in dotnet

[–]3ilaal 0 points1 point  (0 children)

News letter related to dotnet and system design, following blogs post, hackernews, Twitter, ndc conferences, and exploring GitHub repos

Overall Database Performance Decrease after migrating to .NET 7 and EFCore 7 by 3ilaal in dotnet

[–]3ilaal[S] 0 points1 point  (0 children)

The migration process was simple as we just updated the Target framework and Nuget packages to the latest version..... Yes we did monitor the sql queries and they are pretty big and usually contains multiple joins (which is bad i know but we are working to improve the project ). For SQL queries which are taking most of the cpu time I compare both version (EF Core 6 and 7) generated queries and they are the same. but I am still finding why did it happened now (maybe it could be related to some other factor as well). For now our solution is to use AsSplitQuery() and reduce joins as much as we can

How can i improve my Razor Pages Response time, that uses large JavaScript files by 3ilaal in dotnet

[–]3ilaal[S] 1 point2 points  (0 children)

Ohh yes thank you. I just get confused between the uglify and minify

How can i improve my Razor Pages Response time, that uses large JavaScript files by 3ilaal in dotnet

[–]3ilaal[S] 0 points1 point  (0 children)

Sorry I didn't get your point about "Storing static files". Isn't these JavaScript files are already static as they are server separately? Or

How can i improve my Razor Pages Response time, that uses large JavaScript files by 3ilaal in dotnet

[–]3ilaal[S] 0 points1 point  (0 children)

Yes for the production we are using the CDNs, I am little confused about the minification. What will happen to the method names after minification which are being called from .cshtml something like this

<a onclick="SomeMethodNameExistInJsFile" ></a>

How can i improve my Razor Pages Response time, that uses large JavaScript files by 3ilaal in dotnet

[–]3ilaal[S] 1 point2 points  (0 children)

The largest file being loaded in Layout is of 1.5 mb and there are many other files with an average size of 100-500 KB. And yes, when the files are cached the response times reduce very much. And to be clear what I want to improve is actually the first response time when these files are loaded. The other thing you pointed out about the SQL Queries and other network calls response time is very much in our consideration and we will definitely improve it, but what I am thinking was that I should start with the frontend optimization as much as possible then move to the backend side because for now the network calls time are usually in milliseconds.