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 four different techniques including code examples to minimize server calls and thereby optimize the performance of your PowerBuilder application for a WAN or the Internet.
-
Partition transactions utilizing stored procedures
-
Partition non-visual logic utilizing server-side non-visual objects (NVOs)
-
Eliminating Recursive Embedded SQL
-
Group multiple server calls into one "group" call with Appeon Labels
