Data Access Layer Design Considerations

To help ensure that data access in your application is optimized for performance, there are several issues that you must consider and a number of decisions that you must make at design time: * Design your data access layer based on how the data is used. * Cache data to avoid unnecessary work. * Connect by using service accounts. * Acquire late, release early.