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

Chapter 4. Unleashing the Power of Queri... > Dynasets Versus Snapshots for Query ...

Dynasets Versus Snapshots for Query Optimization

Although the dynaset is the default record type in the query, the snapshot is faster. For example, if you are creating records to populate a control for a combo box you use a snapshot record type, provided that the read-only (non-updateable) attribute of this record type is acceptable. Another example is querying a huge table just to send the results to a report. You might consider using the snapshot record type. Just be sure that you don’t need to edit the results.

✓ For more information about creating records to populate a control for a combo box, see “The Power of Controls Revisited” in Chapter 7, “Exploring Objects.”


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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