??????? The IICS project did a half, during which a VB.NET project was taken during the period, including the online learning, and further understanding .NET technology. Looking back It seems that IICS architecture should be reasonable, but there are still many optimized places. Some can be done, I have been revised, and there are more places involved, and this project is not necessarily revised, and the design will take these factors into the way.
1. Use Type Dataset (XSD) in the project to pass data, and see the reference 2 article for the advantages and disadvantages of DataSet. Simply put is easy to use sacrificial performance. If you need to use SqlDataReader when you need to display data in performance, try to use Index instead of the field name when using Dataset and DataTable, in order to facilitate the readability of the program, you must establish an enumeration type, through enumeration Type to transfer integers
2. About the aspx.cs code, page display is based on Page_Prereper, only write permission to judge and take Protected variables, initialization, etc.
3. About the database, using Identity as the primary key, which can simplify the SQL statement, or improve query data (Int index is much faster than String index). Use the stored procedure instead of the SQL statement can also greatly improve access speed.
4. When you need to splicing String, try to use StringBuilder instead of String. I have changed a lot of places.
5. Try not to use the Foreach loop, use the for loop instead, and improve performance.
6. Try not to use a web control when you don't use a web control. Affect the page generation speed. Reasonable use of ViewState
7. In the previous period, try to write a code generation tool (or download one) before the project, reduce the duplication code
reference:
1, .NET optimization scheme http://download.microsoft.com/download/a/8/7/A87398E7-F02D-47AA-BB84-043EB44337FA/ASP.NetPerformenCACHE_PPT.ZIP
2, use DataSet to implement Data Transfer object? Http://www.microsoft.com/china/msdn/library/Architecture/patterns/espx/impdtodataset.mspx
