Home > Forum > ASP.NET > need to increase the speed of my application . data are fetched from the sql server 2005 it take too...

need to increase the speed of my application . data are fetched from the sql server 2005 it take too much of time . how to increase the speed

by celv   on Oct 21, 2014   Category: ASP.NET  |  Views: 954    |  Points: 5   |  Bronze 
  Reply
need to increase the speed of my application . data are fetched from the sql server 2005 it take too much of time . how to increase the speed

Bookmark and Share:
 
  User Reply  | Ask a question  |   Reply 
  Re :need to increase the speed of my application . data are fetched from the sql server 2005 it take too much of time . how to increase the speed   
by Thamil
on Oct 21 2014 1:57AM
Points : 10
Gold 
hi celv

Could you provide some additional informations on this, how or the way of retrieving data from sql server and how long does it take to load the data etc.
  Re :need to increase the speed of my application . data are fetched from the sql server 2005 it take too much of time . how to increase the speed   
by celv
on Oct 21 2014 2:32AM
Points : 10
Bronze 
it takes 50 seconds to fetch the data. and sometimes it takes 2 minutes to open the form.
  Re :need to increase the speed of my application . data are fetched from the sql server 2005 it take too much of time . how to increase the speed   
by Thamil
on Oct 24 2014 12:55AM
Points : 10
Gold 
Hi celv,

Use stored procedure to retrieve or update for database operations. Also refer the below URL

http://stackoverflow.com/questions/5618204/how-increase-the-performance-of-asp-net-application
http://msdn.microsoft.com/en-us/library/ff647813.aspx
http://www.dotnetfunda.com/articles/show/45/best-practices-to-improve-aspnet-web-application-performance

Thanks.

Recent Post

Latest Posts