Excessive server calls in a given operation can create performance issues for that operation on slow and high-latency networks. If you are not familiar with the concept of "server calls", please refer to Impact of the Internet and slow networks and then proceed with this section.
This section will provide different techniques including code examples to minimize server calls and thereby optimize the performance of your PowerBuilder application for the cloud.
-
Grouping multiple server calls with PowerServerLabel
-
Partition transactions utilizing stored procedures
-
Partition non-visual logic utilizing server-side REST APIs
-
Eliminating recursive embedded SQLs
-
Eliminating DataWindow computed fields calling user functions that have embedded SQLs
