I’m studying for a MS certification and one of the practice tests I’m doing has a question where the point of contention is the performance between storing the session in SQL Server as opposed to StateServer.
Has anyone got this working in a web application?
I’ve been working on a web application in ASP.net. My application has several pages and all of them need to display tables that are populated by a database. Right now what I’m doing is, on each page, I’m opening a database connection, executing the query specific to that page, and closing the db connection. So this happens each time the user clicks a link to go to a new page or clicks a form control like the grid page.
I have an ASP.NET page with this pseduo code:
What is the fastest way to execute a method on an ASP.NET website?
I have a reoccurring issue where a customer calls up and complains that the web site is too slow. Specifically, if they are inactive for a short period of time, then go back to the site, there will be a minute-two minute delay before the user sees a response. (the standard browser is Firefox in this case)
I click on a link from one page that does a redirect to another page (Response.Redirect(page.aspx)).
I have a query from a web site that takes 15-30 seconds while the same query runs in .5 seconds from SQL Server Management studio. I cannot see any locking issues using SQL Profiler, nor can I reproduce the delay manually from SSMS. A week ago, I detached and reattached the database which seemed to miraculously fix the problem. Today when the problem reared its ugly head again, I tried merely rebuilding the indexes. This also fixed the problem. However, I don’t think it’s necessarily an index problem since the indexes wouldn’t be automatically rebuilt on a simple detach/attach, to my knowledge.
In Visual Studio there is a command to remove unused using statements
I am trying to minimize calls to ScriptResource.axd but i have failed. Below is the result