Last post Mar 13, 2020 07:23 AM by Rena Ni
Mar 09, 2020 05:57 AM|Prathamesh Shende|LINK
Mar 09, 2020 12:15 PM|PaulTheSmith|LINK
The first thing is to work out what is taking a long time. Is the problem only for the first person who touches the web site? Web server process startup can be slow if you are using shared hosting. Is it only slow for the first database access? WHere
is the database? This node or another? Again, database startup time can be slow.
Or is the problem for everyone everytime? Are the rows the same everytime? Can you hardcode the data rather than fetching? Do you have correct indexes on the table? WHat does the query optimiser show you?
There is never a magic 'go faster' button. You have to measure so that you know what is the bottleneck (DON'T guess, you will guess wrong).
Mar 09, 2020 12:32 PM|PatriceSc|LINK
For example you have tools such as https://developers.google.com/web/tools/lighthouse
Assuming the HTML for the page is quite big, a common change is to not show all rows upfront but to provide a filtering and/or paging UI so that the app can show the user what he wants to seee and 50 rows for example at a time...
Mar 10, 2020 08:34 AM|Masterpiece88|LINK
There are many things to increase your website speed, such as disable session state, turn off tracing, etc. Please refer to this post https://windowswebhostingreview.com/asp-net-hosting-tips-how-to-increase-your-asp-net-performance-for-seo/.
You can also read many tutorial in google.
Mar 10, 2020 09:08 AM|Rena Ni|LINK
Or how do i cache query results ?
It seems you could use distributed caching in ASP.NET Core.
Mar 10, 2020 04:17 PM|Prathamesh Shende|LINK
I checked data fetching takes time,
my hosting is shared hosting, the other css and js are load fast its almost take
1ms time, but data fetching takes 1.2seconds to load and show into html table format. I have correct index its and use clusterd and non clustered index by getting result on execution plan result. I made changes to opimize table.
What do you think where is exact issue is it with Hosting ? or something else ?
Mar 10, 2020 05:34 PM|PatriceSc|LINK
What is the size of your HTML page ? When showing too many rows most of the time is spent in downloading and rendering the HTML markup rather than really on server side operations.
Mar 11, 2020 04:58 AM|Prathamesh Shende|LINK
its 1.8mb size of html page its showing almost 5000 rows in table.
I also applyied paging and search for it. I am using bootstrap-tables js it does all searching, paging and ordering.
Mar 13, 2020 07:23 AM|Rena Ni|LINK
There are several results causing the website's performance so slow.For example:
1.downloading the data from website is slow;
2.Redering the view is slow;
3.The code backend makes the website slow.
For the backend performance,you could try the following code to check which method waste too much time and then you could share the code to us.We would help you how to improve it.