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.
View 5 Replies
I am working on a website hosted with GoDaddy, SQL Server 2005. I have a table in my SQL Server database with a full-text index. On my website, a user can type in search terms and the terms are then passed to a stored procedure in the database which performs the search. The first search takes about 45 seconds to get results. Subsequent searches return results immediately. I found a description of this problem in a Microsoft knowledgebase article:http://support.microsoft.com/kb/915850/en-usGoDaddy tech support says I need to purchase a dedicated server to make the changes suggested in this article.Surely there is some other solution. Does anyone know how to avoid this delay without changing the server configuration?
View 1 RepliesI 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?
In development, our Asp.Net 4 website takes a fairly lengthy time to start after the project libraries are built
We do a fair amount of population of statics etc, but not enough to justify the length of time it takes the app to come up (probably 3-4 minutes)
We aren't building the website, just the libraries, and batch != true in the compilation element in the .config file.
I will try log some diagnostics, but any other pointers would be useful
Project
I'm running a single page (default.aspx) web site in Visual Studio 2010. I have a few other projects in the solution, but they're all taken out of the build queue at the moment. I'm using Visual Studio Development Server as the web server (I haven't tried IIS yet). I'm using the HTML5 Boilerplate from [URL] I'm testing in Chrome and IE8
Problem
Visual Studio 2010 is outputting "Debug" information to the Output window every time I refresh my browser. Whilst this isn't a problem in itself, it seems to be extremely slow in doing so... it takes around 4 seconds to show the page in full from initial refresh.
I've noticed that the "Script Documents" folder appears in my solution view, and some files (notably JS files) seem to take a while to show up. I've tried removing all the JS and CSS file references from my page, but it still does it.
So, to troubleshoot I've created an index.aspx page with no content apart from the generic ASP.Net template code, set this as the start page, but it still takes just as long to load up as the other page.
As a last resort, I've created a new project and tried it with no changes to the default page - still the same, takes a few seconds to finish loading in either browser.
The strange thing is that this happens even when I stop debugging in Visual Studio and browse directly to the URL on the ASP.NET Development server.
Output Windows contents when page is refreshed
[Code]....
Whenever I stop debugging an ASP.NET IIS web application it seems to take very long before VS2010 becomes responsive again (2 or 3 minutes). This happens when I close Internet Explorer 9 (which stops the debugging session), stop debugging in VS (which closes the browser) or when I detach the debugger from the debugging menu (which leaves the browser open).
My CPU time for devenv.exe goes up to 25% during this period of time. I use the professional edition (no intellitrace). Starting without debugging performs ok when I close the browser. I have some add-ins and extensions installed like TestDriven.NET, Resharper, PowerCommands, Productivity Power Tools, VisualSVN,...
Checkout/Checkin takes a long tim
View 1 RepliesI have selected around hundred data and then bind to the repeater each times it take a long time to save data after clicking the save button. How can i improve the performance?
View 6 RepliesI am working on a web application in C#. I am using FormsAuthenticationTicket to authenticate the user. The user's information is check against a sqlserver database, if the correct credential is entered, (combine the username and password, encrypt them using the FormsAuthentication, and assign the random number generated to a session.), the users is redirected to a welcome pages.
However, I notice that there are times when I run the application, and it takes over five minutes to display the login screen, or I have to stop and start the application in order to display the login screen . Does anyone have an idea what may cause this issue?
I have a webpage with 6 drop down lists. User can start with selecting any drop down list first, and then proceed in any order. 1. Assume when the 1st dropdown is selected first, rest 5 drop downs (except 1st) are filtered/updated based on the selected value in the 1st dropdown.2. Assume user selects the 4th dropdown second, rest 5 drop downs (except 4th) will be filtered/updated but the condition would be based on both 1st drop down and 4th drop down. But while filtering the first drop down, only the 4th drop down is used as filter (self-filter will be ignored).
The code works fine but I see a very bad performance hit in time when the user selects the fourth dropdown after selecting three drop downs. I tried using both SQLDataAdapter and SQLDataReader but neither used to solve the issue. The code takes a lot of time on one line in either of the code (which is highlighted below). When I run the query in SQLServer Mgmt Studio, the query completes in a few seconds.
[Code]....
I have a stored proc that takes a bit long to run. I tried to do this command.CommandTimeout = 200;still gets time out within 200 secs.How is this done?
View 1 RepliesRetrieving image from sql database, on pageload takes too long, sometimes 6-8 seconds long. That is too much time to retrieve a binary file and display it on image button. How can I retrieve image in just 2 seconds?
View 1 RepliesThere is a table contains thousands of records. when I run this query:
[Code]....
The application stucks...it takes too much time to execute this query...
What might be the reason for that?
Linq code sometimes takes too long to execute
View 4 Repliessaving my aspx file takes too long, it has some nested tables, but it is nothing huge, it has like 50+ overall controls on the form. When I hit the save button, it takes a few minutes and drives cpu crazy, so I am guessing it is doing something in the background.
So, what is the reason, any clues how to speed this up?
I am using Vs.Net 2010 Ultimate
I have an application which imports data from csv to sql server 2005. It is taking long time to import data from csv to sql server 2005. it has a timer. on tick of timer, I am checking if current rown in csv exists in database. If it exists, It is not added to sql server otherwise, It is added that row to sql server 2005. Also, In page load, It checks on each tick, whether user is logged in or not. it adds value to log file that user is logged in. How can I optimize this ?
View 1 RepliesI 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.
View 6 RepliesI've been trying to get image caching working for the last 8 hours and I keep the same problem time and time again, I'm trying to cache Images at the moment and then when thats succesful, apply this to cache my js and css files. I have at the moment Sql Dependancy caching working on my dynamic pages but the page still takes to long due to images not caching.
What I have tried is going to IIS7 Management and adding HTTP Response Header for the images folder and setting various things for the cache control.i dont care how long it caches it on the client or on the proxy servers i just would like it to check when the file was modified and compare it with the one in the client or proxy cache and if they are different then fetch the new image which has been ftp up. i could solve this by changing the image name but the thing is the image name is generated when they are ftp'd to the site by an application and the name is a direct reference to the product so i cant change the name each time, as it would mean making a lot of otherpages accross the board.
so What i would like, is to set and expiry date of lets say 32 days or more on the images and then check to see if they have changed by date modified or some other way of checking(Etags maybe) I'm not sure, if they have changed on the server then redownload and recache them, I tried using post-check and pre-check together but that just permantly cached them, so when i change the image the only way it would display the new image is to just hit F5.
In Brief, how can i Cache images, on the client machine/ proxy cache and recache them when the modified date of the file has changed.
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();
[Code]....
I there I have recently created an ASP website wich uses .net 4 and SQL db but soem some reason even displaying 20 records in a gridview is slow... So after some reading I converted the website to a Web Application Project so its compile prior to publish.. But yet again this is a bit slow. pages loading time is not of a bit issue...
View 8 RepliesThe SQL below takes at least 7 second to run and may even time out.
There are a lot of records over a million in each of the two tables being inner joined and then being searched on.
I have tried putting an index on the create_date# and rdat# hoping that sql would not have to access all the records
But it seems to have made no difference, so I have now deleted those indexes.
I realise that manipulation of strings comes at a price but I can only work with the data I have been given.
Do you have any tips or trick that I can use to optimise this code?
-- Description: Finds all customer infomation that matches at least two params
-- =============================================
ALTER PROCEDURE [dbo].[usp_FindMatchesInDAProspect.bak] [code]....
I have a aspx page which contains 6 user controls which will be displayed when the user clicks on any button using show model pop up extender. My page rendering takes more time. it taked 3 minuits to load the page. If i debug the page its traveling to page load of all the user controls. Its not taking more time to fetch the data from database but its taking time to load the page. Is there any way to improve the perfomace .Is there any place where i have to look into.I am using VS 2010 and c# .
View 2 RepliesI'm copying one datatable into another like this:
temporaryTreeData = treeViewData.Copy();
How could I figure out how much time it takes for the copy to complete?
here .aspx file in one website is communicating with .asmx file in another website so its taking some time to displat the simulator.
View 2 RepliesPrincipalContext.validatecredentials(username, password);
Takes more time and high cpu usage to validate.
Is there any alternative way to validate credentials or any way to reduce the load and time?
