Instead of trying to write "heavy" logic more efficiently or avoiding use of "heavy" logic, the simplest way is just to offload all that "heavy" logic to the application server, which is designed to handle the most daunting tasks. The only catch is that only non-visual logic can be run at the application server.
The following types of non-visual logic can be encapsulated in PowerBuilder NVOs and deployed to the application server to eliminate "heavy" logic from the Web browser:
-
Complex non-visual events and functions, especially non-visual events and functions that contain dynamic SQL, Cursor statements, Stored Procedure calls, and other SQL statements.
-
Validation of updated data.
-
A series of data computations or a complex data computation.
