• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 21. Client/Server Strategies > Selecting the Best Recordset Type

Selecting the Best Recordset Type

Sometimes it is best to create a dynaset, and at other times it is more efficient to create a snapshot. It is very important that you understand which choice is the most appropriate for a given circumstance.

In essence, a dynaset is a collection of bookmarks that enable each record on the server to be identified uniquely. Each bookmark corresponds to one record on the server and generally is equivalent to the primary key of the record. Because the bookmark is a direct pointer back to the original data, a dynaset is an updatable set of records. When you create a dynaset, you create a set of bookmarks of all rows that meet the query criteria. If you open a recordset using code, only the first bookmark is returned to the user PC's memory. The remaining columns from the record are brought into memory only if they are referenced directly using code. This means that large fields, such as OLE and Memo, are not retrieved from the server unless they are accessed explicitly using code. Access uses the primary key to fetch the remainder of the columns. As the code moves from record to record in the dynaset, additional bookmarks and columns are retrieved from the server.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint