ASP.NET and SQL Server Performance Tips

While such components, as the DataGrid, speed up development, they often reduce the performance of your web-based application. For example, it is much more efficient for you to manually format data retrieved from a SQL Server database using the appropriate HTML code than it is to use a DataGrid component to format and display the data for you on a web page. [7.0, 2000, 2005] Updated 5-16-2005


For best performance, always take advantage of early binding, not late binding. Early binding is faster because the CLR (Common Language Runtime) has to do more work for late bound objects. [2000, 2005] Updated 5-16-2005


Often, the performance of index access in a loop is faster than using a collection. This is because the CLR (Common Language Runtime) is sometimes able to optimize array indexes, but the same is not true for collections. [2000, 2005] Updated 5-16-2005

Pages: 1 2


No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |