Technique #1: grouping multiple server calls with PowerServerLabel

The PowerBuilder PowerServerLabel object provides label functions to merge and send multiple requests in one call. As suggested by the object name, these label functions only take effect when the application is deployed via the PowerServer project (they will be ignored when the application is deployed via the PowerClient project or the Application project).

  • StartMerge and EndMerge -- These two label functions must be used in pairs. They notify the application not to send database requests after the StartMerge function until the EndMerge function is called, so that multiple database requests can be sent in one call.

When these label functions are executed in the PowerServer environment, PowerServer will handle certain database operations differently than PowerBuilder with the aim of reducing the number of server calls. These label functions will not be executed or modify how the application works in the traditional client/server environment.

StartMerge and EndMerge label functions work in the same way as the of_startqueue and of_commitqueue Appeon Labels in old PowerServer (Appeon for PowerBuilder). If you have used Appeon Labels, you can easily migrate Appeon Labels to PowerServerLabel. A few code examples are provided here.