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

Chapter 21. Client/Server Strategies > Using Key Set Fetching

Using Key Set Fetching

The fact that dynasets return a set of primary keys causes problems with forms. With a very large set of records and a large primary key, sending just the primary keys over the network wire can generate a huge volume of network traffic. When you open a form, Access retrieves just enough data to display on the form. It then continues to fetch the remainder of the primary keys that satisfy the query criteria. When keyboard input is sensed, the fetching process stops until idle time is available. Access then continues to fetch the remainder of the primary keys. To prevent the huge volume of network traffic associated with this process, you must carefully limit the size of the dynasets that are returned. The section “Optimizing Forms,” later in this chapter, explores methods you can use to limit the size of your dynasets.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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