PowerBuilder 5.0 has increased DataWindow performance by:

• Using "describeless" retrieves by building a column list directly from the DataWindow structure rather than the database interface.  This feature has been Implemented for Oracle, ODBC, and Sybase.
• Skipping the step of getting a result set description to validate the SELECT statement against the database server before retrieving data. This should make data retrieval faster, especially when you are accessing the database over a network.
• You control this feature with the StaticBind DBParm parameter, which is set to 1 or 'Yes' by default. (The default for StaticBind in Version 4.0 was 0 or 'No'.) StaticBind is supported for most Powersoft database interfaces. This feature is also referred to as "describeless" retrieval. For complete information, see the description of StaticBind in Connecting to Your Database.
• Adding a "Rows to disk" option in the 32-Bit environment.  The Rows to disk option writes the retrieved rows to a temporary file for faster subsequent access.