Wednesday, March 7, 2012

How to improve asp.net Web application performance

 For application performance you need to some r & d on your query mean stored procedure  
 see their retrieval cost and find where it is taking too much time to retriev the data  
 and do some action on that table.  
 For eg.   
 1.You should be use index whereever required  
 2.Use joining if required otherwise remove unnesseary join.  
 3.Select only required field from table.  
 4.you can using caching  
 5.Create index for the table field which you are frequently using in where clause.  

1 comment: