This chapter looks at one of the most critical issues for all data store programmers: performance. Microsoft has stated that one of its goals for ADO was to achieve the best performance possible. However, during testing and through its various versions, the newsgroups have contained several messages regarding poor performance. What I plan to do here is show you whether those criticisms were justified.
KeywordsCache Size Execution Plan Prepared Statement Local Cache Static Cursor
Unable to display preview. Download preview PDF.