外文翻译改进ADO.NET性能.doc

附 录 1.英文资料 Improving ADO.NET Performance Improving .NET Application performance and scalability Summary: This chapter provides proven strategies to help you design and develop scalable data access solutions. Topics covered include different techniques to pass data across application layers, managing the database connection pool, optimizing stored procedure calls, reducing dataset serialization cost, techniques for paging through large result sets, managing transactions, handling BLOBS, and much more. Objectives Optimize your data access design. Choose between DataSets and DataReaders. Run efficient database commands. Pass data between layers efficiently. Perform efficient transactions. Optimize connection management. Evaluate the cost of paging through records. Evaluate criteria for analyzing data access performance. Apply performance considerations to binary large object (BLOB) manipulation. Overview Well-designed data access code and data processing commands are essential elements for application performance and scalability. Typically, the database is a focal point for application load because the majority of application requests require data that comes from a database. This chapter provides proven strategies for designing and implementing data access code for performance and scalability. How to Use This Chapter Use this chapter to improve the implementation of your data access code for performance and scalability. To get the most out of this chapter, consider the following: Jump to topics or read beginning to end. The main headings in this chapter help you to quickly identify and then locate the topic that interests you. Alternatively, you can read the chapter beginning to end to gain a thorough appreciation of the issues that affect ADO.NET performance. Use the checklist. Use "Checklist: ADO.NET Performance" in the "Checklists" section of this guide to quickly view and evaluate the guidelines presented in this chapter. Use the "Architecture" section