Determine Time It Takes To Copy Datatable Into Another
Sep 21, 2010I'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?
I'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?
I have a web application which has rather a lot of controls. I also have several buttons (add, edit, save, cancel). Most of my content page is in an update panel so it does not process the whole page. On form submit I have some javascript code which shows a div 50% opacity and an animated gif to prevent users clicking on the buttons more than once whilst it is processing the data to the server. Here is the javascript / call:
Code:
onsubmit="overlay();"
function overlay() {
el = document.getElementById('overlay');
el.style.display = "inline";
document.getElementById('Image2').src = "../Images/loader.gif";
}
function removeoverlay() {
el = document.getElementById('overlay');
el.style.display = "none";
}
The problem is it the form disables like I want it and the giff animates for about 1.5 seconds but it does not enable the form for a further 4 seconds.
Is there anyway to see what it happpening at this point. If I put some watches in my code behind it runs through less than a second so what else can it be doing.
Also on some laptops the form does not fit vertically so there is a scroll bar. When the div is shown on a submit it does not do the full screen including the scroll area.
i have the dataset with one table.Table contains three column like 'Name','Location','Pin'.I would like to move the data from another table based on schema.
View 2 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?
how to copy data from datatable to table in dataset i ry this but its readonly property
ds.datatable1=newdt.copy
how to copy only the columns in a DataTable to another DataTable?
View 2 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 Replieshere .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 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 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 Repliesi have searched quite a bit on this one and can't seem to find exactly what I am looking for.
I think my first problem is this: How would I bring back a DataTable FOR copying? I know I would need:
Dim dt as Datatable
But then how do I get the Original Datatable in there? I think that once I have that part, I can just make a connection to my new DB inside a copy subroutine (using the .Copy method) and be done with it. That part I have the code pretty much done for, I think.
I am trying to implement ajax auto complete control using a standard webservice. inside webservice a table adapter is called which will return a dataTable containing a single column. this table adapter uses a stored procedure with following script
View 3 RepliesI want to copy rows from one datatable to another.
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]....