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 RepliesI 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?
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.
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 RepliesWhat is the advantage of using a Mex Endpoint over setting
[code]....
I am not able to add the service using Add Service Reference. I am not able to get the WSDL using a browser.
2. If I add the tag <serviceMetadata
httpGetEnabled="true"
and remove Mex Endpoint, I am able to query the wsdl using browser and I am still able to add a refernce using Add Service Reference.
Then, What's the specific use of Mex Endpoint.
I am supposed to create a intranet web application and the question is what technology I will use? is that the ASPX with C # or the Java EE. in any case I want to know the great advantages that I will receive.
View 4 RepliesSince Themes in ASP.NET are used to style elements of your site, I was just wondering why would you use Themes rather than CSS, or is it common practice to use both? If so, when would you opt for one versus the other and why?
Just seems to me like Themes are kind of unnecessary, so I am just looking on clarification if there really is a good reason to use them, or it's just a part of the framework as an alternative(unnecessary) step to styling your site.
I hate webform that no matter what action is done with a client side page(such as clicking a dropdownlist to only see the Items), it cause a postback&re-rendering of the whole page and all of the page events is raised( page_init,page_load....complete....).
We know that the server side .cs page shoudnt have to go through all the events and many methods(such as "IsPostback",viewstate), in fact,it just have to do only one thing:get data from DB for the dropdownlist and show it to us, other part of the page just doesnt have to change.
We may achieve this effect using Ajax, but the key is I dont wanna raise too many useless event .
seems MVC can handle such a problem, one action of browser side is replied by exactly one method,and time isnot waste by raise event...
Is this the biggest advantage of MVC?
Possible Duplicate:
MVC versus WebForms
What are some of the advantages of using one over the other?
I am new to Entity frameworks-EF. As, EF is built on top of ADO.NET...If so, will there be any performance issue when we use it?Same way MVC also targets Test Driven , rapid application development only ..What speciality does it add for end-users?As per my understanding ASP.Net 2.0 itself is powerful without MVC and/or EF...
View 7 RepliesWe want to launch our website in two different countries. for that which one is the best option
Use same domain in both country, use different domain for each country
I am relatively new with the usage of asp.net and AJAX technologies and i am trying to add some ajax functionality to my web application.So, I was interested in finding out what the advantage is of using asp.net ajax libary and controls over the usage of simple javascript XMLHttpRequest.
View 3 RepliesSee in below I have writtine a
1. Singleton class Emp1 with Display Method and
2. Static Class with Static Method Display.
What is the advantage of singleton class over Static Class with Static members?
[Code]....
i want to develop intranet application.can i deveop it as a windows application.if it so what is the advantage than web application
if we develop windows application is it requires server?
If I use SqlDataSource control in my asp page to retrive data in viewgrid and some dropdownlist control then what is advantage and disadvantage?
View 1 RepliesI am trying to take advantage of the Content Delivery Network Support and have run into a snag
I set the script manager to look like this
<asp:ScriptManager ID="ScriptManager1" runat="server" EnableCdn="true">
I'm using ASP.NET 4 and the routing engine. In my Global.asax I have something like this.
routes.MapPageRoute(
"Items",
"manager/items",
"~/Manager/Item/Items.aspx"
);
Is writing a link this this acceptable?: <a href="/Manager/Items"></a> Should I be using the <% %> tags and code within to retrieve the route name, "Items" in this case?
When i started developing web applications i stored the authentication details of the user in two session variables
Session["UserName"]="username";
Session["Password"]="paswword-123";
But someone proposed me an idea to create a class which holds the UserName and Password properties and on succesful authentication i have been asked to create an instance of the class and set the UserName and Password properties and store that instance in the session.
I have been told that the session object is TypeSafe. Can someone explain what is typesafe coding and the advantage of storing the object in the session.
i want to know Advantage and Disadvantage of lock in OLTP system??
View 2 RepliesI have this function in aspx page.
[Code]....
and I call this function from JavaScript as below:
[Code]....
I want to know what is this technique called and what is the advantage of calling the function on that way
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.
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 RepliesI 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 RepliesI 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.
I have a strange situation on a production server. Connection for asp.net get queued but the CPU is only at 40%. Also the database runs fine at 30% CPU.
Some more history as requested in the comments:
In the peak hours the sites gets around 20,000 visitors an hour.
The site is an asp.net webforms application with a lot of AJAX/POSTs
The site uses a lot of User generated content
We measure the performance of the site with a testpage which does hit the database and the webservices used by the site. This page get served within a second on normal load. Whe define the application as slow when the request takes more than 4 seconds.
From the measurements we can see that the connectiontime is fast, but the processing time is large.
We can't pinpoint the slowresponse the a single request, the site runs fine during normal hours but gets slow during peak hours
We had a problem that the site was CPU bound (aka running at 100%), we fixed that
We also had problems with exceptions maken the appdomain restart, we fixed that do
During peak hours I take a look at the asp.net performance counters. We can see behaviour that we have 600 current connections with 500 queued connections.
At peak times the CPU is around 40% (which makes me the think that it is not CPU bound)
Physical memory is around 60% used
At peak times the DatabaseServer CPU is around 30% (which makes me think it is not Database bound)
My conclusion is that something else is stopping the server from handling the requests faster. Possible suspects:
Deadlocks (!syncblk only gives one lock)
Disk I/O (checked via sysinternals procesexplorer: 3.5 mB/s)
Garbage collection (10~15% during peaks)
Network I/O (connect time still low)
To find out what the proces is doing I created to minidumps.
I managed to create two MemoryDumps 20 seconds apart. This is the output of the first:
!threadpool
CPU utilization 6%
Worker Thread: Total: 95 Running: 72 Idle: 23 MaxLimit: 200 MinLimit: 100
Work Request in Queue: 1
Number of Timers: 64
and the output of the second:
!threadpool
CPU utilization 9%
Worker Thread: Total: 111 Running: 111 Idle: 0 MaxLimit: 200 MinLimit: 100
Work Request in Queue: 1589