Using DataWindow expressions

Generally speaking, DataWindow expressions will slow-down the initial display or subsequent refresh of DataWindows. As such, Appeon recommend you reduce the usage of DataWindow expressions if possible, especially in the following situations:

  • Avoid using DataWindow expressions for computing and setting column properties.

  • Avoid setting sort and filter criteria directly for a DataWindow object. Instead, write the sort and filter criteria in the SQL statement of the DataWindow object. As noted previously, it is faster to use SQL statements than DataWindow functionality.