- Connection Pooling : Connection between Web Application and SQL Server is expnsive. So, connection pooling can improve performance.To use connection pooling, use the same connection string. Also , open the connection, do the work and then close the connection.
- Paged Data Access : Datagrid with paging would show fixed number of records. Suppose a Datagrid is bound with 100000 records but if page size is 25 , then Datgrid would display only 25 records out 100000 records. Data layer has to fetch all 100000 records and bind to Datgrid hence performance would be bad. So , Paged Data Access would really improve performance wherein you fetch only fixed number of records to be shown in Datagrid using stored procedure.
- Caching : Caching data would improve performance. Data is used more than once is good situation to use Caching. Also, data is general and not user or request specific is an ideal situation for Caching
- ViewSate : Viewstate is used to store state data in hidden field in page.When the page is posted back to the server, the server can parse, validate, and apply this view state data back to the page's tree of controls. There are a number of drawbacks to the use of view state, however. First of all, it increases the total payload of the page. There is also an additional overhead incurred when serializing or deserializing view state data that is posted back to the server. Lastly, view state increases the memory allocations on the server.So diabling View State will improve performanca of page.Within a control, you simply set the EnableViewState property to false, or you can set it globally within the page using this setting.
- Return Muliple RecordSet : Returning multiple recordset will improve performance by reducing time spent and resource spent to cumminicate with SQL
State few tips to improve performance of Web Application ?
Tips to improve performance :
Subscribe to:
Post Comments (Atom)
Popular Posts
-
RegisterStartUpScript This adds the javascript code at the end of the page before the closing of form tag. RegisterClientScriptBlock Th...
-
delegate string Delegate1(object o); delegate object Delegate2(string s); static string Dispaly(object o) { r...
-
@@ERROR is a global variable used to return error number of last T-SQL.
-
Please follow below steps to enable transaction in Web Service : 1.Add a reference to System.EnterpriseServices.dll. 2.Add the System.Ente...
-
Authentication is process of obtaining credentials such as username and password and validating the credentials. There are 3 types of ASP....
-
window.open
-
To be in second normal form i.e 2NF , all information attributes or fields of the table are attributes of entity of table schema. All inform...
-
Replication is the way to keep data synchronised in multiple datbases. SQL Replication consists of two important part : Publisher - Datab...
-
The WebMethod attribute in Web Service provides the following properties: BufferResponse CacheDuration Description EnableSession Messa...
-
Computed Column is virtual column in table whose value is computed at runtime.The values are not stored in table but computed by the express...
1 comment:
Good Help
Post a Comment