C# - Long Time To Load First Sql Connection In .NET?
Apr 9, 2010
For some reason it takes 7 seconds to open a connection to a sql server database for the firt time, subsequent connections takes a second.
I'm using C# and asp.net
Its after compilation, i essence every time i restart the site, which means every time it needs to actualy create the "first" connection. i understand that setting up connection pooling has overhead, but i have never seen that i should take 7 second to set it up.
I am working on a ASP.NET 2.0 application. It is hosted on IIS 6 on Windows 2003 server.
Few pages have jpeg images (around 50 images and 50 KB each). It takes long time to load the page for the first time. But when i open the same page for the second or third time it is faster.
why does a web page take long time to load for the first time?
Is it cached somewhere when it loads for the first time? Do we have any control over it?
I have tested my pages in Firefox & IE and looking at Firebug in Firefox for some reason some images are taking a long time to load. They are not very big in comparison to the ones which are loading quicker.
Attached is a screenshot of Firebug.
I especially notice it in IE with the progress bar at the bottom of the page, it just sits there saying loading image...
Could it be the path or something which is http://localhost:49211/Content/_layout/images/bg-footer.png for example
I have a web page which has a textbox and a button. The textbox has a calendar extender attatched to it.On my machine it is popup quickly but when i published it on the server it's taking a very long time to show and sometimes it doesn't. It's like loading or downloading something. Any Clues .....
i developed a website already and it was hosted in live too. My Problem is , site take a very long time to load , it take nearly 30-60 seconds to open , once it opened then it is some what better, MY Url Ishttp:\shoesrus.msinternational.bizplease verify and give me a solution , is their is any setting changes has to be taken in iis or server side etc..
I am retrieving records from database nearly 380 records and binding them to a repeater control.My page is taking long time to load. how to improve the performance and here is the code of my repeater.
I am trying to create a progress bar for page load as it takes long to load. I need help to resolve jscript error 'null' is null or not an object on line $get("btn").click();
I have developed an application in asp.net with crystal report. It has more than 30 pages in the project. Now I want to improve the performance of the application.1. What I need is , I want to know each and every page loading time and where actually it take long time to load while requesting the page.There are so many tools available. But am not able to follow as where actually the problem is and how to solve.
In an asp.net web form, I keep getting a connection reset error message. The page is doing a some long running processing (about 2-5 minutes).
I have no problem when the web request comes from the same machine as the web server. But when the request originates across the network, I get a connection reset error about 1:30 or 2 minutes into waiting for a response.
I have set the in web.config for this application and put the application it's own application pool.
What else can I try?
Edit
The purpose of this page is to accept input from the user, calculate something, and send the result back to them. The long running calculation isn't something I can offload until a later time.
Am working currently on a project with Dundas chart and to populate 3 similar charts on the dashboard page, there are more than three thousand rows returned from the database for each chart. These rows now retrieved are just test data and while launching the application there would be enormous amount of data being retrieved. It takes ample of time for the page to load on every postback. Is there any way to load the page more quicker inspite of huge data being populated.
It looks likes if I don't visit my low traffic site for a day, it takes a long time for the first page to load. I believe it's probably because IIS7 shuts down the application when it receives no requests for a certain length of time. I have a dedicated server so I have all the access required to change things in IIS
I have a project in .net 3.5 SP1 (Visual Studio 2008) and it took approx 5 to 10 minutes to load. My sln contain 3 projects. how can I improve efficiency.
My machine specs are
Intel(R) Core(TM)2 Quad CPU Q8200 @ 2.33 GHz 2.33 GHz, 1.96 GB of RAM
We deplyed an application to a host, my default asp.net page load 3 small catalogs, this delay to load about 15 secondsthe first time, Can I do something about it
i have a web aplication in asp.net 2.0. i have configured it using IIS when i am trying to access the webpage even thr' the IIS , the page is not getting displayed.there is no error msg nor any msg , but nothing appears even for a very long timethe webapplication was wrking fine 2 days back
after nearly 5 mts i get a msg Thread was being aborted. Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Threading.ThreadAbortException: Thread was being aborted.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
I want to implement user login function , that allow user to login after couple of weaks without asking username and password again. I have read many article and got that it is maintain by Cookie but don't know how to implement this one. A good example is seen in gmail, facebook [URL] .... that allow user logged in for couple of weaks. I also want to maintain a cookie table for just keepig the records of user logged in from different system.
I have used session in my application for admin panel. It is redirecting if i not use 1 or 2 minutes. I need to stay session until I click logout button.
I have a .Net 4.0 MVC 2.0 web application I built using VS 2010 Ultimate. I have about 413 lines of jQuery with no infiniate loops or anything, just ajax calls, .hide(), .show(), .slideToggle(), etc....the usual stuff. However, when I run the page both in debugging (Vista Enterprise 32bit) or in production (Server 2008 Enterprise 64bit w/ IIS 7) I get the following Windows Internet Explorer message dialog box that pops up:
Stop running this script? A script on this page is causeing Internet Explorer to run slowly. If it continues to run, your computer may become unresponsive.
I commented out all 413 lines of my jQuery and this didn't fix a thing. So, then I started to comment out the external js files my page points to, and when I removed this line, the problem stopped, but my page also doesn't function are look right.
[Code]....
I have Googles the hell out of this error, and have found all sorts of reasons as to why this can be caused, and have seen many solutions, even Microsoft has a solution for it which involves a registry mod, but I can't do that since it would have to be done on every client machine. Does anyone know why this js file would be causing this problem? If there just too much js on the page with this file added?
I figured the MVC discussion board would be the place for this since us MVC developers use the hell out of jQuery most.
I have a page that takes a long time to load because it utilizing multiple user controls. Is there a way where I can display a wait animation during the page loading utilizing JQuery? I'm a newbie to Jquery and client side development
whenever I replace a master page on my site the pages load after a few hours(1-2) and only after that the site returned to work as normal.. I dont use VS "open web site" from the web method, instead I download the page I want to change (using flashfxp for instance), make my changes and upload it back. I do this process because every now and then the VS stuck/not responding/think long time. he master pages I change are used by few thousand of pages in the site, my thought is that whenever I change a master all the site get rebuild and therefor the long loading time..
I have IIS 7.5 running on windows 7 64 bit machine.
My problem is that in my web application after any page request if the page remains idle for more than 2 mins, it stops responding. For e.g. lets take the following scenario:
1. Initial page request
2. the page stays idle for 2 mins
3. Click a button to save data
4. It takes very long for the aspnet worker process to reach page_load, and firefox shows "connection was reset" message.
I put breakpoint on page_load. It strikes the breakpoint after a long time and also it does not go to the event handler of the button that was clicked.
The web application works perfectly if the page is not kept idle.
When I try to delete files or directories within the solution explorer, they take an excessive amount of time to delete. When I say excessive, I mean I almost had enough time to type this post out before a directory with nothing in it was finally removed. I'm using visual studio 2010 on Windows XP SP3 and I primarily program in MVC/C#.
One of my web pages populates a droplist with about 60k items pulled from SQL Server, and this operation takes upwards of 10 seconds to complete. Are there some tricks or optimizations I can try to improve performance? I'm using a SqlDataSource configured as a DataReader.
