ADO.NET :: Performance Advantage To Using EF?

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

Similar Messages:

Configuration :: .Net Website Performance Of 2 Sites - Rectify The DB Performance While Insertion?

Sep 20, 2010

I have developed a website in 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

DataSource Controls :: LINQ Performance Application Performance Is Not Up To Par?

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

WCF / ASMX :: Wcf Performance Vs Page Events Performance?

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 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

WCF / ASMX :: What Is The Advantage Of A Mex Endpoint

Feb 8, 2011

What is the advantage of using a Mex Endpoint over setting


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


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.

View 2 Replies

.net - Advantage To Use ASPX / C# Vs J2EE

Aug 4, 2010

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 Replies

Advantage Of Themes Versus CSS?

Jan 24, 2010

Since 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.

View 2 Replies

MVC :: What Is The Biggest Advantage In Comparison With Webform

Jul 25, 2010

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?

View 5 Replies

Biggest Advantage To Using MVC Versus Web Forms

Sep 22, 2010

Possible Duplicate:

MVC versus WebForms

What are some of the advantages of using one over the other?

View 2 Replies

Architecture :: Advantage Of Using MVC And/or Entity Framework

Oct 2, 2010

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 Replies

Web Forms :: Is There Advantage If Use A Different Domain For Each Country

May 5, 2014

We 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

View 1 Replies

AJAX :: Advantage Of Library Instead Of Simple XMLHttpRequest

Mar 4, 2010

I am relatively new with the usage of 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 ajax libary and controls over the usage of simple javascript XMLHttpRequest.

View 3 Replies

Architecture :: Advantage Of Singleton Class Over Static?

Mar 30, 2010

See 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?


View 9 Replies

Web Forms :: Develop Internet Application - What Is The Advantage

Oct 12, 2010

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?

View 3 Replies

Web Forms :: Data Retrieve In Webpage / What Is Advantage And Disadvantage

Sep 2, 2010

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 Replies

AJAX :: Trying To Take Advantage Of The Content Delivery Network Support

Jul 26, 2010

I 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">

View 3 Replies

Best Practice For Making Links That Take Advantage Of Clean Urls

Mar 24, 2011

I'm using ASP.NET 4 and the routing engine. In my Global.asax I have something like this.


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?

View 1 Replies

Typesafe Coding And The Advantage Of Storing The Object In The Session?

Nov 24, 2010

When i started developing web applications i stored the authentication details of the user in two session variables


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.

View 3 Replies

SQL Server :: Advantage And Disadvantage Of Lock In OLTP System?

Oct 15, 2010

i want to know Advantage and Disadvantage of lock in OLTP system??

View 2 Replies

AJAX :: Advantage Of [WebMethod] Function At Aspx Page Called By JS Code?

Dec 19, 2010

I have this function in aspx page.


and I call this function from JavaScript as below:


I want to know what is this technique called and what is the advantage of calling the function on that way

View 3 Replies

C# - ASP.NET Performance Issue

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

Performance: Using LoadControl In For-each?

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

How To Improve Performance Of A Gridview

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

Looking For Data Layer To Use For Performance?

Jul 29, 2010

I did not post this in database forum because the data will run on an 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 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

Performance - Application Slow But CPU Is At 40% Max?

Nov 19, 2010

I have a strange situation on a production server. Connection for 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 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 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:

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:

CPU utilization 9%
Worker Thread: Total: 111 Running: 111 Idle: 0 MaxLimit: 200 MinLimit: 100
Work Request in Queue: 1589

View 3 Replies

Copyrights 2005-15, All rights reserved