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

RecordSet.setDeliveryMode( ) Method > RecordSet.setDeliveryMode( ) Method

Name

RecordSet.setDeliveryMode( ) Method

Synopsis

                     myRecordSet.setDeliveryMode(mode, pagesize, numPrefetchPages)

Arguments

mode

The mode to use in fetching pages from the server (”ondemand“, "fetchall“, or "page“).

pagesize

The number of records to return in each page (required in "fetchall" and "page" modes).

numPrefetchPages

The number of pages to retrieve from the server (required in "page" mode).

Description

The setDeliveryMode( ) method allows you to set the mode of pageable resultsets from a ColdFusion Server. The different modes are:

"ondemand"

The delivery mode is "ondemand" by default. It simply means that the records are returned when they are requested. Use "ondemand" mode when each record is needed individually and at different times. Do not use this mode if you are iterating through the entire recordset at once, because it forces the client to make a separate request for each record, which is very inefficient. The mode is efficient only if you won’t eventually load all the records and you want to limit network traffic to only those records that must be loaded. Also, it is fine for small recordsets where all records will download at once.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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