Beginning with the 7.1.2 release, every web module in e-Business has
the option to “Enable On Demand Data Fetch”.
When checked, the application will only fetch the required columns for the web module. This is solely a performance related control. While this checkbox has been added universally to all web modules, it may not be applicable to all modules. No repercussions will occur if checked on a non-applicable web module.
Within the API, all the data related properties are categorized into three levels–Level 1, Level 2, and Level 3. If the Enable On Demand Data Fetch checkbox is checked, when the first call to the API is made, only Level 1 fields are filled. If the user tries to refer to a Level 2 field after the API has been filled, another SQL statement is executed to fill the Level 2 fields. Level 3 fields are similarly referenced.
The On Demand feature gives you the ability to reduce the amount of data returned by the API dramatically, however, the feature should be used judiciously. If all of the columns in the table are needed for the web module, then the number of calls to the database will increase and performance can drop.