I have table for past four years. It had a records for around 10 Lacks it was taking lot of time to execute so i removed recordes from the table. Table size was reduced to 29 thousand. Still when i execute a query from my application it takes more than 2 minutes to return.
View 4 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?
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 need to find out the query execution time from the front end .Where should I insert the code for that.
I am using the bleow query:
OracleConnection con = new
OracleConnection(ConnStr);
con.Open();
OracleCommand cmd =
new
OracleCommand("Stored_Proc",con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add();
....................
................
OracleDataAdapter
oda = new
OracleDataAdapter
(cmd);
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?
Linq code sometimes takes too long to execute
View 4 Repliesam querying an Oracle database thru an ASP.NET web page, but the other day, the webpage didn't show any results after 5 minutes which normally takes about 3 secs. Then, 3 hours after, I got an email from the IT Dept asking me to kill my task which was taking a lot of ressources, but I couldn't since there is no way to send a user cancel request as I can do for instance with SQL Naviguator. So, they had to kill it for me. However, I do't want it to happen again because I don't want to overload the servers because of a query that didn't execute properly.
So, I thought about including connection timeout into my connection string, but there is already a default value. So, is it possible to avoid that kind of situation?My code contains a try {} finally {} to trap errors, but I didn't seem to work in this case.
The 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?
I am a PHP MYSQL person but now i have got webiste to do it ASP.net.I kow nothing about ASP.NET. INitially i was thinking of ASP.NET as a programming language but now i now its not , i really don't know what it is.Someone told me that i have to do c sharp to build the website. I i have to display simple data from database how much different is c sharp from php.Does it has all function like php to echo stuff etc
View 4 Repliesi have 4 dropdownlist controls in a page. each have more than 6000 records. when retrive the records from DB there is no issue and taking very less time. after getting the records it takes too much time to display in the the page. here no problem with db retriving.. i guess problem is with page weightage. how can i solve this problem..
View 3 Repliesif I hit the .aspx page on the browser and if the page takes time to load say may be 25-30 seconds then what are the steps to be taken to make sure that the page loads quickly. In other words what could be the reason for this slow loading.
View 3 RepliesI have 10 000 000 words, I need to use
[Code]....
to search for specific word. It is very quick in finding the word, but when loading that amount of data to my dictionary it takes a while. Could you say what is the efficient way deal with such data? This is not homework or work related, but it is my personal project.
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 RepliesI have a tree-view which doesn't have any events and AutoPostBack property is also false. But whenever the treeview node is selected,its taking a lot of time...The tree view is placed inside update panel...I have an update progress and selection of any node shows the progress for atleast 5-6 seconds.
The code is as below :
<asp:UpdatePanel ID="updatePnlListBoxes" runat="server">
<ContentTemplate>
<table align="center">
<tr>
[Code]....
The script manager is in Master page.
I have developed a web application in .net & if the web application is idle for some time & after that if we perform some action on that web page then it doesn't respond.
View 1 Repliesi am having the problem that i am using datareader to get contents in my asp.net page.But the page takes a lot of time to load.How to decrease the loading time of the apage and increase the performance of my page.
View 1 RepliesIn 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]....
I've dynamically made an ImageButton, the problem is when I hover the Image, it takes a few seconds to load the hover image (imgHover.png in my code)..
Is there a way to preload the images or something?
heres my code:
[Code]....
I am dynamically creating a table of checkboxes on my test.aspx page. The dimensions (row and column count) of the table are determined by querying the database. In test.aspx page, I do the following:
<script language="C#" runat="server">
protected void Page_Load ( object src, EventArgs e ) {
//Query the database to get the data for rows and columns
CheckBox[] chkBox = new CheckBox[rows * columns]; //creates a collection of checkboxes
//Iterate over the query set in a double for loop to create dynamic checkboxes
}
</script>
Right now I have the number of rows=20 and columns=10, but it can increase (with the columns more likely). I used the Net tab in Firebug to ascertain the time taken by different events and found that GetTest.aspx is taking close to 4 minutes, which is too long a time to wait. Is there a way to being down the page load time? Is my approach to create dynamic check boxes correct?
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,...