Chapter 3: Designing a Cursor and Caching Strategy


Overview

ASP.NET and ADO.NET offer many ways to increase the performance of applications that access data from a data source. For data that is not updated frequently, you can consider caching, which involves the temporary storage of data outside of a database. Caching provides an opportunity to optimize network and server resources. ASP.NET offers three ways to implement caching; finding the right caching solution depends on the requirements of your application. Lesson 1 will cover considerations you need to make when designing a caching strategy. From there, the chapter moves on to discuss using cursors to efficiently handle row-by-row operations.

Cursors allow you to work with one row or a group of rows at the same time. When used properly, cursors can provide an opportunity to optimize server memory and improve application performance. When designing an application that uses cursors, it is important both to know where to implement cursors and to recognize when it is not appropriate to use cursors. This chapter will explore the considerations you need to make when designing a cursor strategy.

Exam objectives in this chapter:

  • Design caching strategies.

    • Select ADO.NET caching.

    • Design custom caching functionality.

    • Design a refresh strategy for cached data.

  • Design a cursor strategy for a data access component.

    • Decide when to use cursors.

    • Decide how to maximize cursor performance.

    • Decide which applications are using cursors and evaluate whether to remove them.

  • Design a cursor strategy.

    • Design cursor logic.

    • Design cursors that work together with dynamic SQL execution.

    • Select an appropriate cursor type.

    • Design cursors that efficiently use server memory.

    • Design cursors that minimize blocking.

    • Design a strategy that minimizes or eliminates the use of cursors.




MCITP Self-Paced Training Kit Exam 70-442  .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
MCITP Self-Paced Training Kit Exam 70-442 .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
ISBN: 073562383X
EAN: N/A
Year: 2007
Pages: 162

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net