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 three different techniques including code examples to minimize server calls and thereby optimize the performance of your PowerBuilder application for the cloud.
-
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
