Configuration :: .Net Website Performance Of 2 Sites - Rectify The DB Performance While Insertion?
Sep 20, 2010
I have developed a website in asp.net framework 2 . This website is being hosted in two different servers without any change in code. My issue is about the performance of these 2 sites. One website is taking much time for inserting datas to the DB (SQL server 2005). 2 websites are having different DB server.
I think the issue is for the DB server. How can we rectify the DB performance while insertion and Is there any other cause for this permance issue?
View 1 Replies
Similar Messages:
Apr 29, 2010
I am not sure if this is the right forum. I can not find a forum for LINQ.
I am working on an application using LINQ. Application performance is not up to par and my tests show that it is LINQ queries that are slow. I was wondering if anybody can recommend where I can find an article about optimizing LINQ performance maybe by compilation or other methods.
View 1 Replies
Mar 20, 2011
I am creating a service oriented application where trying to have everything using services....however there is something I am not sure of , I am having a page that calls the database at the page load...so what would be better and faster?? to call database in pageload , or to call wcf service from javascript during javascript load ??btw , I am using a repeater in the page , but I have created somekind of an engine to create the suitable html so...I'll be creating the repeaters html using the wcf and resend it back to the page If I am using a wcf service at the start.
View 1 Replies
Jan 12, 2010
I'm trying to add some performance counters to my asp.net website. Now, I know how to increment/decrement some custom counter I make .. but my problem is that if I get my ASP.NET website to create these counters, if they do not exist (eg. i do this check in the global.asax App start method) then add/create them.
But, it doesn't work - access to the registry is denied/forbidden.
I'm assuming this is because the asp.net process is so stripped down (for security) that u can't touch that type of thing. Therefore, i'm wondering if the only other solution is to make a quick console or winform app which does one thing -> add's the perf counters. running this as my normal logged in user would me i have admin rights, so it will work. or is there something else i can do?
View 2 Replies
Apr 12, 2010
I am a web designer and usually design corporate web sites which often does not require update. So I want to cache the output for one day. How can I do this?
View 4 Replies
Jan 21, 2011
I should store application configuration data and default text values that will have the best performance overall. For example, I've been sticking stuff like default URL values and the default text for error messages or application instructions inside the web.config, but now I'm wondering if that will scale...
View 4 Replies
Jun 14, 2010
In my webpage, the page uses lots of images and css. The time taken to load the initial home page is huge.What are the ways,which can be done in IIS 6.0 to improve the performance?I checked few results in google, which talked about File expiration policy and enabling http compression in IIS 6.0. In the Enable content expiration, what value should be ideally used?In the Custom Http header, what should be added to improve the performance.
View 4 Replies
Jun 5, 2010
I had created a web site with asp.net and sqlserver. How can i improve the my website's performance in with regard sqlserver connection?What's your mind about use pool connection? In this regard what the defualt values is set for 'Max Pool Size' and 'Min Pool Size'?What's your mind about use Asynchronous access to data? What's your mind about other ways that you think?
View 3 Replies
Aug 3, 2010
I needed to test the performance of my site on a remote server (do not have IIS access). I am also using Visula Web Developer / Studio Professional 2008 (But not team system version).
View 2 Replies
Jun 11, 2010
When my Application face a long-time process, i.e fetch a query (SELECT a, b, c FROM d)This query needs 10 seconds to be completed in the MSSQL Management Studio, but when the ASP.NET application try to fetch it, it refuse to return any response to any other requests made on that Server.
I am hosting my Application on VPS Server with good specifications, and I am giving this example the (SELECT a, b, c FROM d) just to tell you the issue, it can be any process, maybe processing a movie, or even fetching some data through external API that is experiencing some slow-down,or whatever.
View 2 Replies
Dec 11, 2010
I have almost 100 website that will update in a condition, I have a winzip archive that contains the files that replaces those websites. I want to know that
I can extract that files in a folder and then copy them to all 100 websites folders
I can extract the archive directly to 100 websites folders
which one is better in performance and less prone to errors
View 1 Replies
Aug 13, 2010
My application is working well in localhost, but it became very slow after deploying in server.
I have used session which stores 2 string values. What might be the reason? Its taking too much time to retrieve page
View 3 Replies
Feb 3, 2011
In my website I am using thread to perform the function which downloads the CSV from a website and parses the data into the database.
Now if I am not able to stop the thread then what could be the impact on the performance?
Also If I unknowingly start another thread then would it impact my website's performance?
View 3 Replies
Dec 8, 2010
I have requirement in website, where i need to provide around 60 textbox inside form.
I woud like to know whether it make performance down when i put such large count of textbox (60) in form.
Is there any alternate way to meet this requirement.
View 1 Replies
Feb 16, 2010
I watched old videos that suggest to test the asp.net website load using Microsoft Web Application Stress Tool. But there is a broken link to get the download. tool to test website performance?
View 2 Replies
Apr 1, 2012
In my website need to display 5000+ records in gridview. So, I used custom paging for static page bar and displaying 100 records per page. In stored procedure using ROW NUMBER() keyword to retrieve specific records from the database. Even though website is running dead slow. Is there any alternate way apart from the ROW NUMBER() to increase the website performance. I followed the below article to achieve custom paging.....
View 1 Replies
Apr 10, 2012
In my website for one project we have 5000+ records in sql database. If I give page size is 100 for gridview then the paze size showing 800kb in firebug net panel and it is taking 20-30 seconds to load webpage. If I give page size is 10 for gridview then the paze size showing 160kb in firebug net panel and it is taking 5-6 seconds to load webpage. If I give page size is 5for gridview then the paze size showing 130kb in firebug net panel and it is taking less than 6 seconds to load webpage. I noticed that due to heavy paze size the performance decreasing but as per my requirent the paze size should be 100 or above and the page should be load less than 2 seconds.
Note: I am using Ajax Update panels
View 1 Replies
Dec 14, 2010
we host the web application on a server and the structure is..
Root
Module1
page1.aspx
Module2
page4.aspx
Temp
archivedImages
image1 image2
The temp folder size is increased every month as we manually add images.
Except the Temp folder every page is requested from the browser...
We dont use the Temp folder for any other purpose other than archive.
Does this affect the performance of the web application i.e. constant size increase?
how different would it be if we moved the temp to some other location out of the Root?
View 1 Replies
Sep 7, 2010
I just had to moved a site of mine from a hosting service here in the states to an offshore host located in Malaysia. My database is still located on the east coast of north america and I am wondering if the distance between the database and the file system might be to blame for slow load times or if moving my database as well would be a waste of time.
View 2 Replies
Mar 17, 2011
Would adding "X-UA-Compatible: IE=EmulateIE7" as an http header to trigger IE9 to render in compatibility mode negatively affect performance on the server? I made the change today, adding it, but now some areas of our site are behaving sluggishly, though we did have a large number of changes come in overnight. I know that we can't single out this as the problem, but my boss seems to think it is.
View 3 Replies
May 20, 2010
I am working on an ASP.NET 3.5, C#, ASP.NET AJAX, JQUERY web application which currently is having some performance issues. I have a screen with the forms view control and when I edit the form and save it for the first time the POST takes 4.89 seconds and when I perform the same operation again for the second time the POST only takes 1.09 seconds. What could be the reason for this strange behavior?
Note: I am using firebug and I am disregarding the page resources (like js, images) load time.
EDIT: I am using the Web Deployment Project to precompile the application.
View 3 Replies
Mar 14, 2011
I'm now getting into EF and from what I'm seeing so far, I wouldn't have to worry about writing stored procedures any more. Looks like EF takes care of all of that -- including INSERT's that store data in multiple tables. One of the things they taught us when learning stored procedures was that they're compiled which has performance benefits. How does EF 4 fare against using stored procedures?
View 3 Replies
Oct 12, 2010
I'm trying to make a decision about how to display my data. What I have now is a list of products displayed in a repeater. But for code-maintenance I've put my product items in a seperate usercontrol and loading them in a loop with db results using LoadControl.The product control itself is very simple, just a few public properties like title, url, rating but I'm not sure if this will affect my performance. I did some reading here and on forums and some people say it's not the best practice especially if you have more then 20 or 30 of these controls. So, is it really a performance hit using this method or does it stay ok with around 10.000 hits a day.
View 2 Replies
Feb 16, 2011
I have developed a gridview which has displays 8,000 records. However, the user is compaining that it is too slow. A major function of this gridview is to filter on two of the columns. It seems to me that if the records were stored in memory it would be much faster. This is caching, I think. Is that the case? Since filtering is being done I don't think custom paging will help much. When they submit a filter, with custom paging wouldn't the entire table be read again? So I was thinking of trying caching which is available on SQL Server. Am I on the right track? Can you cache with an Access database? Can you think of any other ways to improve performance of a gridview?
View 1 Replies
Jul 29, 2010
I did not post this in database forum because the data will run on an asp.net site.I have 3 solution in my mind and i would like some opinions.What i want to do is create a parent-child relationship on 2 controls.A listbox and a textbox.I will populate the listbox with data(this is taken care of so ignore) and what i want to do is when i click on an item in the listbox then the textbox to show it's joined related item(one item only).This is not a problem in windows forms app but in asp, since i'm new i don't know what would be better for a faster retrieval on the page.So the 3 options i have in mind are:
1)DAL.The standard create a query and let one @parameter wait for the id.
2)ADO.NET with possibly an sqldatasource.In standard forms i would have chosen simple ado.net but in asp?So either constantly open,close the db and retrieve the item or use an sqldatasource and chance the parameter.
3)Asynchronous handler page.Bind the textbox to an asynchronous page that contains the connection and expect the @id parameter.
I admit that i'm not fond of DAL but if it will boost speed then i will use it.But i have a though that says that simple ADO will be faster.
View 16 Replies
