What are the Most Efficient Cursor and Lock Types?
All of our tests so far have used a Forward Only cursor to iterate through the recordsets. However, ADO offers three other cursor types for recordsets – Static, Dynamic, and Keyset. Each of these provides additional functionality, such as the ability to move forward and backward and see changes to data as others are making them. Unfortunately, it is out of the scope of this article to discuss the implications of each of these cursor types. I will have to leave this up to you. However, below is a comparative analysis of each type. Each of these additional cursors impose significantly more overhead than their Forward Only cousin ( ADO__03.asp ). In addition, these cursors are slower during iteration. The caution that I would like to share with you is to avoid the trap of thinking, “Well, every once in a while I need a Dynamic cursor, so I will just use that all the time. Essentially, the same issues apply to lock types. Our previous tests have been exclusively using the Read Only lock ty
Related Questions
- The types of locks or latches you need are the same for door handles on a backplate, door handles on a rose and door knobs. For information on lock and latch sizes please see FAQ What backset size do I need?
- Who does the home secretary want to lock up for life?
- What are the Most Efficient Cursor and Lock Types?